Page 1 of 1

how to find max salary using transformer stage not aggregato

Posted: Wed Jan 07, 2009 6:26 am
by adisheshu.dwh
how to find max salary using transformer stage not aggregator stage


pls help me

Posted: Wed Jan 07, 2009 6:35 am
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.

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

Posted: Wed Jan 07, 2009 4:16 pm
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.