update the target table with max date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 41
- Joined: Sat Jun 06, 2009 11:13 pm
- Location: Kolkata
First sort then remove duplicate
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.
Nayan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In server jobs the Aggregator stage has First and Last as set functions per group.
Last edited by ray.wurlod on Tue Jul 07, 2009 12:08 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 44
- Joined: Fri Mar 16, 2007 5:51 am
-
- Premium Member
- Posts: 48
- Joined: Tue Nov 25, 2008 11:10 pm
- Location: Des Moines,IA