Post reply

Change Tracking

  • June 4, 2013 at 8:52 am

    #75676

    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

  • July 23, 2013 at 6:42 am

    #1634919

    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

  • March 12, 2014 at 11:42 am

    #1696496

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply