update the target table with max date

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Jul 06, 2009 3:10 am

Did you trying using aggregator and doing max(date) in it?

nayanpatra · Post by **nayanpatra** » Mon Jul 06, 2009 3:33 am

First you read the oracle table using ODBC stage. Next sort the records in ascending order using EMPLID, EMPL_RCD and EFFDT as key. Next use the remove duplicate RDUP stage using EMPLID and EMPL_RCD as the key and retain the last record. Thereby, you will have the record according to your requirement. Next do whatever update you want. I think this will work. Just check it out.

chulett · Post by **chulett** » Mon Jul 06, 2009 8:31 am

People, we're in the Server forum with the Job Type marked as Server so please stop handing out PX solutions.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 06, 2009 6:15 pm

In server jobs the Aggregator stage has First and Last as set functions per group.

seshikumar · Post by **seshikumar** » Mon Jul 06, 2009 11:59 pm

thanks for your quick response.

i got solution.

datskosaraju · Post by **datskosaraju** » Tue Jul 07, 2009 12:08 am

seshikumar wrote:thanks for your quick response.

i got solution.

Can you please post your solution

DSXchange

update the target table with max date

First sort then remove duplicate