how to find max salary using transformer stage not aggregato

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
adisheshu.dwh
Participant
Posts: 12
Joined: Tue Aug 26, 2008 10:48 pm

how to find max salary using transformer stage not aggregato

Post by adisheshu.dwh »

how to find max salary using transformer stage not aggregator stage


pls help me
ADISHESHU.P
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Transform stages can use stage variables to store values (i.e. to aggregate or compare values). If you have a stage variable MaxSalary that states "IF In.Salary > MaxSalary THEN In.Salary ELSE MaxSalary" that variable will contain the highest salary encountered in the run so far.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Re: how to find max salary using transformer stage not aggre

Post by ray.wurlod »

adisheshu.dwh wrote:using transformer stage not aggregator stage
Why? Give me a good reason not to use the right tool for the job.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”