Dear Tabla,

Could you please elaborate that how can you use merge for incremental data load... it will be really of great help if you can give one example that how to use the suggested update or insert flag while using merge...

thanks and rgds,
ranjeet

Better and effective way to achieve Incremental Data Load using PL/SQL

Hi,

There are some better and effective way to achieve Incremental Data Load using PL/SQL (if you have control over your sources)...
# Create the similar schema as in Source (that means if source has 100 tables that is going to be used to populate target, create similar table structures in this replica schema...you should add some audit columns...