topic Re: SCD with static table schema in Talend Studio

SCD with static table schema

aisbel — Thu, 19 Apr 2018 11:57:03 GMT

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

Re: SCD with static table schema

aisbel — Thu, 19 Apr 2018 12:09:09 GMT

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

Re: SCD with static table schema

manodwhb — Thu, 19 Apr 2018 12:39:31 GMT

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

Re: SCD with static table schema

aisbel — Thu, 19 Apr 2018 13:53:19 GMT

Yes.. thank you for your replay

the problem has been solved