HOW TO FIND OUT MAX SALARY USING TRASFORMER STAGE

adisheshu.dwh · Post by **adisheshu.dwh** » Wed Jan 07, 2009 5:12 am

HOW TO FIND OUT MAX SALARY USING TRASFORMER STAGE
HELP ME

THANKS IN ADVANCE

ray.wurlod · Post by **ray.wurlod** » Wed Jan 07, 2009 5:17 am

Welcome aboard.

Please do not shout. (All capitals = shouting.)

Why do you specifically want to use a Transformer stage? It is more usual to use an Aggregator stage to find a maximum (or perhaps an SQL query).

It can, of course, be achieved, using the fact that stage variables are evaluated in the order in which they appear in the grid, so that a value from the previous row can be remembered. Therefore you only need to compare the current row with the previous row and update the running maximum where it is larger.

DS_SUPPORT · Post by **DS_SUPPORT** » Wed Jan 07, 2009 7:08 am

interview question?

keshav0307 · Post by **keshav0307** » Sat Jan 10, 2009 6:20 am

do you know how to find the MAX salary, similar logic will apply in your job

Alokby · Post by **Alokby** » Sat Jan 10, 2009 10:24 am

Use Stage variable.
compare prev to curr
set max
Save previouse value