duplicate data should pass to one file.....................

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
dssubhani
Participant
Posts: 38
Joined: Wed Jul 14, 2010 11:12 pm

duplicate data should pass to one file.....................

Post by dssubhani »

1. i have duplicate data....in which duplicates pass to one file and non duplicates pass to another file

how?[/b]
subhani
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Use aggregator to find the count on key fields and join this result to your original data and use count to send data to duplicate file or non-dup file
You are the creator of your destiny - Swami Vivekananda
Post Reply