I have a Netezza ELT Input Component which selects data from source table (say customer where fields are cust_id, name, age, gender, address, timestamp).
I have linked input to Netezza ELT Map Component which has the fields from the source table.
I have linked ELT Map to ELT Output Component for update (say customer_1 where fields are cust_id, name, age, gender, address, last_modified_date, last_modified_operation).
Not I wanted to update the customer_1 table for the matching cust_id of customer table but only the latest row.
customer - Source Table
customer_1 - Target Table
Only the red rows should have been updated. After ELT:
How do I achieve in ELT?
What should I write in ELTMap?
Solved! Go to Solution.
Any job setting screenshot could be uploaded into forum?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema