Computation

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
chowdhury99
Participant
Posts: 43
Joined: Thu May 29, 2008 8:41 pm

Post by chowdhury99 »

Use transformer sate and stage variable.

Thanks
ArjunK
Participant
Posts: 30
Joined: Sun Apr 30, 2006 6:32 pm

Post by ArjunK »

You can remove dups on all four keys and then just aggregate on all four. Where ever the count is greater than 1 set record as 'MULTIPLE'.
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

ArjunK wrote:You can remove dups on all four keys and then just aggregate on all four. Where ever the count is greater than 1 set record as 'MULTIPLE'.
If you remove duplicates, you cannot have multiple. So the count will not be more than 1.
ArjunK
Participant
Posts: 30
Joined: Sun Apr 30, 2006 6:32 pm

Post by ArjunK »

Sainath.Srinivasan wrote:
ArjunK wrote:You can remove dups on all four keys and then just aggregate on all four. Where ever the count is greater than 1 set record as 'MULTIPLE'.
If you remove duplicates, you cannot have multiple. So the count will not be more than 1.
My bad. Remove duplicates of four and then aggregeate on the first three.
Post Reply