topic Re: SCD example in Talend Studio

SCD example

Anonymous — Tue, 05 Feb 2013 08:22:17 GMT

Hi,
I am very new to TOS. I have played around with some components. Now I am trying to look into some SCD step-by-step examples. Could you please point me to any such example.
Thanks,

Re: SCD example

Anonymous — Tue, 05 Feb 2013 08:45:18 GMT

Hi,
Do you want to get the SCD component reference guide? We promoted Talend Help Center to new talend user which provides a structured source of enriched information and knowledge, certified by Talend, where you can quickly and easily find out how to make best use of the full range of Talend products.
Hope it will help you.
Best regards
Sabrina

Re: SCD example

Anonymous — Tue, 05 Feb 2013 09:04:42 GMT

Hi Sabrina,
Thanks for your quick response. Yes, I am looking for SCD component reference. The Help center doesn't contain any information on SCD. The tutorial section doesn't have anything on SCD.
Regards,

Re: SCD example

Anonymous — Tue, 05 Feb 2013 09:18:14 GMT

My apologies, I was able to find the required information in Components section.
Regards,

Re: SCD example

Anonymous — Tue, 05 Feb 2013 09:21:47 GMT

Hi,

The Help center doesn't contain any information on SCD

There are some component references about SCD, such as tMysqlSCD, tOracleSCD and so on...What kind of SCD reference do you need? More info about that will be preferred.
Best regards
Sabrina

Re: SCD example

Anonymous — Tue, 05 Feb 2013 09:23:56 GMT

Hi,

My apologies, I was able to find the required information in Components section.

It is great to know that.
Best regards
Sabrina

Re: SCD example

Anonymous — Fri, 20 Feb 2015 11:43:26 GMT

trying to create a simple SCD2 using tMySqlSCD and getting the below issue. have modified the city for siva. the results is improper as per scd2.. plz help.. m new to talend..
Starting job scd21 at 22:00 19/02/2015.

connecting to socket on port 3496
connected
connecting to socket on port 4377
connected
.--+-----+-----+---+----+-----.
| tLogRow_2 |
|=-+-----+-----+---+----+----
|id|fname|lname|age|city|grade|
|=-+-----+-----+---+----+----
|1 |avi |kumar|20 |chn |a |
|2 |jit |kumar|22 |del |a |
|3 |siva |singh|18 |hyd |b |
|4 |him |roy |28 |del |c |
'--+-----+-----+---+----+-----'
.--+-----+-----+---+----+-----+---------+-------+-----------+----------+---------+-----------------------------------------------.
| tLogRow_1 |
|=-+-----+-----+---+----+-----+---------+-------+-----------+----------+---------+----------------------------------------------
|id|fname|lname|age|city|grade|scd_start|scd_end|scd_version|scd_active|errorCode|errorMessage |
|=-+-----+-----+---+----+-----+---------+-------+-----------+----------+---------+----------------------------------------------
|3 |siva |singh|18 |hyd |b |null |null |0 |false |23000 |Duplicate entry '3' for key 'PRIMARY' - Line: 2|
'--+-----+-----+---+----+-----+---------+-------+-----------+----------+---------+-----------------------------------------------'
disconnected
disconnected
Job scd21 ended at 22:00 19/02/2015.