Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Change Tracking Expand / Collapse
Posted Tuesday, June 4, 2013 8:52 AM


Group: General Forum Members
Last Login: Friday, January 15, 2016 8:44 PM
Points: 161, Visits: 508

We have a need to load some OLTP data into DW based on last time the data got updated/inserted. Rows in OLTP get updated sparadically, one record can get updated 0-4 times between loads and we need to pick up only records that changed/got inserted. Other than using update_date (which is a solution, but requires a lot of code changes) we are looking into implementing Change Ttracking. But from what I see, change tracking keeps track of versions for each row, which means we need to keep track of each version in DW as well to know which recrods changed by joining the two data sources. Since our DW gets loaded incrementally (every 15 minutes) those joins would be too expensive, hence the question: Is there a way to use Change Tracking without keeping track of each version for each record?

Post #1459809
Posted Tuesday, July 23, 2013 6:42 AM


Group: General Forum Members
Last Login: Friday, August 26, 2016 5:58 AM
Points: 19, Visits: 137
I guess you require this for incremental loading correct? Change Tracker is a summarized table which keep tracks of the tables with respect to the latest modified date. Simple way is to create a table which will have say 2 fields ie table name and latest_date column. Once you have calculated the delta then update this table with the max date. so always this table will have the latest date associated to the table name.

Hopefully this answers your question.

Rahul Sahay
Post #1476545
Posted Wednesday, March 12, 2014 11:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, January 23, 2015 2:58 PM
Points: 1,194, Visits: 2,243
There is difference between Change Tracking and Change Data Capture. CDC stores previous versions. CT doesn't. Check if CT helps for your scenario.


Post #1550363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse