From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

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

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

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog