Home » RDBMS Server » Performance Tuning » data pull from a table (oracle 10g unix)
data pull from a table [message #366288] Fri, 12 December 2008 12:08
Messages: 48
Registered: February 2007
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,
Previous Topic: Converting Trace (.TRC) file to readable(HTML) file in forms 10g
Next Topic: How SELECT affects remote database from which data is selected
Goto Forum:

Current Time: Sat Oct 22 21:27:14 CDT 2016

Total time taken to generate the page: 0.09161 seconds