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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog