topic Re: implementing scd2 in Talend Studio

implementing scd2

Anonymous — Thu, 14 Mar 2013 06:07:06 GMT

please anyone suggest me how to implement SCD 2 in talend? im new for talend

Re: implementing scd2

Anonymous — Thu, 14 Mar 2013 07:13:00 GMT

Nearly for all database types you find SCD related components. The interface to configure it is very user friendly and fits very well to the theory of slowly changing dimension types.
You will find at start your schema column in the unused sction and simply drag and drop them to the SCD type as you need.
You can configure the timestamp fields as well as an active field.
Hint: If you design your table and add it to the meta data and use this meta data to create your SCD output, please let the scd columns in the unused section or better switch to a build-in schema and delete them from schema because they will only be handled be the SCD component.

Re: implementing scd2

Anonymous — Thu, 14 Mar 2013 10:34:16 GMT

Hi,
Do you want to use the SCD component in talend? There are some component references about SCD, such as tMysqlSCD, tOracleSCD and so on. Could you give us more info about your requirement so that we can give you a proper help.
Best regards
Sabrina

Re: implementing scd2

Anonymous — Thu, 14 Mar 2013 12:07:47 GMT

please anyone suggest me how to implement SCD 2 in talend? im new for talend

Hi Manju,
We have a property in output components of all DBs ( for example tMySqlOutput) named ' Action on Table '
and ' Action on data ' .
Set ' Action on Table ' to ' Default '
Set ' Action on Data ' to ' Insert or Update ' / ' Update or Insert '.
We can achieve SCD2 using this property I guess.
Hope this would be helpful.
Thanks,
Saty.

Re: implementing scd2

Anonymous — Thu, 14 Mar 2013 20:41:07 GMT

Hi Saty,
NO that is not an SCD feature! Slowly Changing Dimension means you track the changes of fields and writes a new time slice for a changed data set. What you describe is simply an update of the existing dataset in different orders (first insert and than update if the insert found an existing one).
Only the tXXXSCD components do this job properly and this for all 3 SCD types.

Re: implementing scd2

Anonymous — Fri, 15 Mar 2013 03:23:09 GMT

Hi jlolling,
Thanks for the corrections. This forum is very helpful to me to explore various features of Talend.

Saty.

Re: implementing scd2

Anonymous — Mon, 09 Dec 2013 09:53:10 GMT

Hi jlolling,
I'm facing a problem with tOracleSCD...It takes alot of time to get finished ..i was looking for output component which make it faster to execute.
Thanks,
Mirella