April 8, 2015 at 3:20 am
Hi experts,
i would like to know the best practices to choose the columns which should be used for delta?.
If, i consider Customer ID as part of delta.. is it the a good idea.
Please provide the valuable information that helps me and every one in this group to understand the delta process much better.
Thankyou and Regards,
Vj
April 17, 2015 at 2:05 am
Delta column in a table is use to do Incremental/Delta loads.
So the prospective Delta columns in your tables could be audit columns like, UpdateDate/ModifiedDate, timestamp, rowversion, ETL_LoadID, etc.
Using CustomerID would be a bad idea, even if its a IDENTITY PK column, as old customers could also be updated as Delta, not only new records.
Check this video "SSIS with Delta Load" for more details: https://www.youtube.com/watch?v=-Kb7uQTB5Ek
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply