Hi,

I know that we can implement SCD type 2 implementation using CDC. This means we need to have history recordsas well, in case of historic attributes have got any changes.

However CDC splitter gives, outputs or pieplines like new record, updated records and deleted records (it doesn't have any provision to provide historic attribute and thus to insert as a new record whith flag isCurrent=1.

So it means we need to get the updated records data set and do some SQL check to find out historic attribute got changed and if yes insert as new record and if not havng any change in historic attribute, we just need to update it?

Any link explains the same?

Thanks!

SHamsuddeen

Hi Shamsudden,

Check the below link. This will help you for sure .

http://sqlmag.com/sql-server-integration-services/combining-cdc-and-ssis-incremental-data-loads