tELTNetezzaMap - Update the latest row of the key in the target table

Seven Stars

tELTNetezzaMap - Update the latest row of the key in the target table

Hello,

 

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.

 

eg.
customer - Source Table

1,xx,23,M,www,2018-01-11 11:00:000000

2,yy,20,nnn,2018-01-11 11:00:000000

 

customer_1 - Target Table

1,xy,23,M,www,2019-03-08 00:00:000000 

1,xm,23,M,www,2018-01-01 00:00:000000

2,yx,20,nnn,2019-02-01 00:00:000000

2,ym,20,nnn,2019-01-01 00:00:000000

 

Only the red rows should have been updated. After ELT:

customer_1

1,xx,23,M,www,2019-03-08 00:00:000000 

1,xm,23,M,www,2018-01-01 00:00:000000

2,yy,20,nnn,2019-02-01 00:00:000000

2,ym,20,nnn,2019-01-01 00:00:000000

 

How do I achieve in ELT?

 

What should I write in ELTMap?

 

Thanks.


Accepted Solutions
Seven Stars

Re: tELTNetezzaMap - Update the latest row of the key in the target table

I fixed this using tJava component.

View solution in original post


All Replies
Moderator

Re: tELTNetezzaMap - Update the latest row of the key in the target table

Hello,

Any job setting screenshot could be uploaded into forum?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: tELTNetezzaMap - Update the latest row of the key in the target table

I fixed this using tJava component.

View solution in original post

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