Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 8824 Views
- Wipro, I also Faced
- E-Mail Answers
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
Enlist various types of routines in datastage.
what is the use of surogate key in datastage
Lookup constraints
What are the features of datastage flow designer?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the purpose of pivot stage and types of containers in datastage
Is it possible to query a hash file?
Define meta stage?
Can you explain repository tables in datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Can you explain engine tier in information server?
How can one find bugs in job sequence?
What is a folder? Difference types of stages?
What is the precedence of stage variables,derivations, and constraints?
What are the steps needed to create a simple basic datastage job?
