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

[Anonymous]

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.

[Anonymous]

Hello,

Any job setting screenshot could be uploaded into forum?

Best regards

Sabrina

[Anonymous · Accepted solution]

I fixed this using tJava component.