Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change Tracking Expand / Collapse
Author
Message
Posted Tuesday, June 4, 2013 8:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 7:19 AM
Points: 161, Visits: 506
Hi,

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?



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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:28 AM
Points: 16, Visits: 113
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.


Thanks
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: 2 days ago @ 2:57 PM
Points: 1,194, Visits: 2,211
There is difference between Change Tracking and Change Data Capture. CDC stores previous versions. CT doesn't. Check if CT helps for your scenario.

http://technet.microsoft.com/en-us/library/cc280519(v=sql.105).aspx

--
SQLBuddy

Post #1550363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse