i want for the 3rd max sal using for the any stage but max
sal is based on the deptno ?
any body know this ans pls send this mail siva3me@gmail.com
Answer Posted / subhash
Src ---> Tfm ---> Tgt
in the TRANSFORMER Stage.
Do the HASH partitioning the incoming data and 'Perform
Sort' on DEPTNO ASC order and SAL DESC order.
and use 2 STAGE VARIABLES sv1=0 & sv2=0.
sv2 ===> If sv1=DEPTNO Then sv2+1 Else 1
sv1 = DEPTNO
And Put the below Link contraint:
sv2=3
Then u will get 3rd highest SAL from each DEPT.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the flow of loading data into fact & dimensional tables?
Which warehouse using in your datawarehouse
What all are the different way to run a job?
How to read multiple files using a single datastage job if files have the same metadata?
What is the process of killing a job in datastage?
which r the connectors used in san?
What are the differences between datastage and informatica?
What are the difference types of stages?
What are the repository tables in datastage?
AGGREGATOR default datatype
what is ds administrator used for?
What is the sortmerge collector?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Explain how a source file is populated?
Differentiate between datastage and informatica?