How to select composite key (combination of 5 keys ) as a business key in Slowly changing dimension transformatio

The PK must exist that comprises these columns 1st which I think is not the case.

Then you would see that in the wizard

Isn't that mapping wizard for Informatica, I'm looking to implement using ssis SCD transformation.

My bad, image changed, the concept remains the same.

I think there are null's in the composite key columns and the records are redirected to input destination every time I run the package, how to handle this.

Hi Sree,

you can have the data inspected to make sure, but NULLs cannot not part of a PK.

Thanks for all your help. Appreciate it!! :)