want actual record and rejct rec in a single table

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
samad40
Participant
Posts: 11
Joined: Wed Jun 13, 2007 2:45 am
Location: chennai

want actual record and rejct rec in a single table

Post by samad40 »

hi,

i need to collect actual record and rejected records in a single table...

my requirement is

to select a max of sal from emp table along with max of sal i need to collect rest of the remaining records in a single target table

WHAT TYPE OF STAGE WE CAN USE TO DESIGN THIS .
samad
John Smith
Charter Member
Charter Member
Posts: 193
Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia

Post by John Smith »

er perhaps a copy stage to split out the data,an Aggregator to get max and perhaps a join to glue it all back?
and just another tip , try not to shout when posting in forums.
Post Reply