Best options for Incremental Loading Reusablity
Posted: Thu Jun 16, 2011 8:37 am
I like to know what are the options available for incremental loading in Parallel version. I know the CDC is one of the option in which we can capture insert, update and delete. Please let me know the other options.
In which design we can it as reusable design?
My source is Oracle and Target is SQL Server. (total more than 87 tables)
I tried using CDC, but I can't able to do as reusable design and also I can't use RCP enabled in Target DRS or ODBC stage for my SQL Server.
Please suggest the best solution.
In which design we can it as reusable design?
My source is Oracle and Target is SQL Server. (total more than 87 tables)
I tried using CDC, but I can't able to do as reusable design and also I can't use RCP enabled in Target DRS or ODBC stage for my SQL Server.
Please suggest the best solution.