Incremental Data Loading
ABC-OCMay 16 2013 — edited Jul 10 2015
Hi, I am loading data in data warehouse from transactional system through oracle data integrator. I want to load incremental data in my warehouse. I found two(2) way,
1- Standard CDC
when I use standard CDC, its create the trigger on source table which is not acceptable for OLTP management team.
2- Use Last Update Date
when I use DATE option it take more resource and time of ETL. Because DATE has 8 charters and difficult to match each record.
Is there any other way to load Incremental data which is very fast ?