| data pull from a table [message #366288] |
Fri, 12 December 2008 12:08 |
dr46014
Messages: 49
Registered: February 2007
|
Member |
|
|
Hi All
We have two databases in our Data Warehouse environment.One database's tables are loaded(full table refresh )every day.After the loading is over data is pulled from the tables in that database in ETL tool and stored in the files which are used for downstream process.Here pulling 80 million data from all 5 tables take a long time.Is there any way we can change the yesterdays dataset to incorporate the changes.i think CDC may help.But on the 1st database we cant do any changes.Infact we are not allowed.Is there any method where CDC setup can be done without any changes in source DB.We can do anything in the tgt DB,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
