Can i select multiple Business keys in Slowly Changing Dimensions ?

Question

In the Slowly Changing Dimension Wizard in SSIS , i have the ability to select multiple Business keys but it doesn't seem to work.
In my case i have reccords that need to be identified by multiple columns .

Answer 1

Hi @Amir Bessaoud ,

As said slowly-changing-dimension-transformation.

The Slowly Changing Dimension transformation requires at least one business key column.

The Slowly Changing Dimension transformation does not support null business keys. If the data include rows in which the business key column is null, those rows should be removed from the data flow.

What do you mean of 'it doesn't seem to work'?

Regards，

Zoe Hui

Answer 2

Hey @ZoeHui-MSFT , thank you for your response,

I am using the scd with Historical Attribute and i am selecting multiple Business Keys to identify the records but i noticed that in the target table i have some duplicate active rows.

My question : Is the scd transformation able to identify and track records in the target based on 2 or plus business keys (muliple columns). Or should i create a new column that concatenate the multiple needed business keys columns and then use it in the scd to track the records.

Thanks.