Posted: Mon Jul 06, 2009 3:10 am
Did you trying using aggregator and doing max(date) in it?
DSXchange
A short text to describe your forum
http://dsxchange.com./
update the target table with max date
Page 1 of 1
First sort then remove duplicate
Posted: 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.
Posted: 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. 
Posted: Mon Jul 06, 2009 6:15 pm
In server jobs the Aggregator stage has First and Last as set functions per group.
Posted: Mon Jul 06, 2009 11:59 pm
thanks for your quick response.
i got solution.
i got solution.
Posted: Tue Jul 07, 2009 12:08 am
Can you please post your solutionseshikumar wrote:thanks for your quick response.
i got solution.