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.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables