Capturing Changes In Data

Hot Topic

Unable to install MS SQL Server..
Perform an experssion in desing mode
Connecting to Oracle on 64-bit (x64) machine
DDL of an existing cube
Creating an update trigger for a multi-table view
How Can I Change the data type of the parameter for the Deployed Stored Procedure ??
Complex XML Parsing/Shredding
Problem encountered during the installation of Visual Studio .NET 2005 Professional on a windows 2000 domain PC
Programmatically loop over variables in the variable dispenser?
Date picker not showing in RS2005

SQL Server

Unexpected failure during the setup of SQL Server 2005 Standard Edition
VS 2005 + sdf + foreign key
Displaying processing time in reports
SQL Server Express will not install -- Existing Components- Cannot Resolve - Help
Rollup
Walkthrough Failu "Creating a Mobile Application w/SQL Server"
What do you miss on SSIS?
CreateSPs Sample Application Causes Exception.
Simulate ROW_NUMBER () in SQL 2000
Pivot Issues

Capturing Changes In Data

I'm looking at how SSIS would cope with populating DW with huge transactional tables capturing only changed data.
Can you use a table comparison transform, or is the approach to look at timestamp log files and 'Last Exection Date variables'.

Any comments appreciated

Answer this question

Capturing Changes In Data

Nico Devriendt
Yes, these are the general approaches.
You also have the option of transaction replication to a staging table, and then periodically running your ETL process.
K
Capturing Changes In Data

Answer this question