SCD with static table schema

[aisbel]

Hi,

I have to you SCD component with tables which have static schema , in order way i am not allowed to add extra columns to the tables like Surrogate keys.

Could anyone tell me if that possible ?

As a try :

I have used Type 1 for all my columns expect the primary key, putting the primary key in the (Surrogate keys).(component) with creation = Input field . as a result an error appers to me.

Best Regards

[aisbel]

Hi again,

I have did the following (as in attached photo) and schema  didnt changed , but i become the error shown in the photo

waiting for your support

Untitled.png

[manodwhb · Accepted solution]

@aisbel , since you need to define Souce keys ,as it is used as the key that ensure the SCD of the incoming data.

I belive in your example ,name shold be the in Soruce Keys section.

[aisbel]

Yes.. thank you for your replay

the problem has been solved