Category "scd"

SSIS Slowly changing dimension column

I'm using a Slowly Changing Dimension in SSIS and I'm using a single column called active of type BIT to determine the latest records instead of start date and

SCD Start and End Date

I am new to ssis and i am a little bit confused about the SCD_Start_Date and SCD_End_Date when we use the SCD dimension wizard. on many examples that i have se