SCD with static table schema

Five Stars

SCD with static table schema

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

 


 


Accepted Solutions
Thirteen Stars

Re: SCD with static table schema

@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.

Manohar B
Five Stars

Re: SCD with static table schema

Yes.. thank you for your replay

the problem has been solved Smiley Happy


All Replies
Five Stars

Re: SCD with static table schema

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

 

 

Thirteen Stars

Re: SCD with static table schema

@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.

Manohar B
Five Stars

Re: SCD with static table schema

Yes.. thank you for your replay

the problem has been solved Smiley Happy