topic Re: Multiple Update of a record using Talend SCD component in Talend Studio

Multiple Update of a record using Talend SCD component

Anonymous — Wed, 29 Oct 2014 13:34:02 GMT

Hello experts,
I have 2 updates for same record in CDC ( So these records will have same values for Unique keys in Target Table) .
My First record goes in but while inserting second record it throws unique key constraint error. Database unique constraint which includes unique Key constraint (same for both records) and start_timestamp . I had first selected Job_Start_time as value for Start in VERSIONING section of SCD component hence it was giving error. Since I want to have 2 different Timestamp for these 2 values I am trying to use "INPUT FIELD" option for start inside Versioning. However After I select this option for start inside versioning, it is giving me compilation error . I have created a variable in previous step (tMap) with same name as start variable and assigned value to it , still no luck .
Screenshots attached here.
Thanks for your help and reading through.
Regards,
Milind

Re: Multiple Update of a record using Talend SCD component

Anonymous — Tue, 04 Nov 2014 02:37:49 GMT

Hi
The function TalendDate.getDate(String pattern) returns a string, if you want to get the current Timestamp, try this expression:

TalendDate.getCurrentDate()

Best regards
Shong

Re: Multiple Update of a record using Talend SCD component

Anonymous — Wed, 07 Jan 2015 05:59:08 GMT

Hi
The function TalendDate.getDate(String pattern) returns a string, if you want to get the current Timestamp, try this expression:

TalendDate.getCurrentDate()

Best regards
Shong

Re: Multiple Update of a record using Talend SCD component

Anonymous — Wed, 07 Jan 2015 06:24:54 GMT

Thanks Shong for your reply.
Please ingore my earlier reply as full text did not go through.
My real problem is :
In Versioning Section, when I change value of column "creation" to "Input Field" for type="start" and name"VERSION_START", I am unable to type anything in "Complement" column.

Thanks,
Milind