Multiple Update of a record using Talend SCD component

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

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch