Need help with configuring this scenario.
I have Delimited File with ID and data associated with it. And I have DB2 table with ID and SeqNbr as primary key and data columns. While reading Delimited File and inserting to DB2 I need to generate SeqNBr.
Sample of how the Delimited file looks:
Here is how I need to generate Seq nbr
Can you please suggest how to achieve this?
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.