One Star

Multiple Update of a record using Talend SCD component

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
3 REPLIES
Community Manager

Re: Multiple Update of a record using Talend SCD component

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Multiple Update of a record using Talend SCD component

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
One Star

Re: Multiple Update of a record using Talend SCD component

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