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
- 8719 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / vinod
SIMPLE ONE IS.
USE THE TRANSFORMER STAGE.
BEFORE LOADING THE DATA IN TO TRANSFORMER STAGE THE DATA
MUST IN SORTED ORDER OF SAL AS DES AND DEPT AS ASC.
IN TRANSFORMER I AM GOING TO USE THE STAGE VARIABLES.
STR IF DEPT=STR1 THEN STR+1 ELSE 1
STR1 DEPT
THEN USE THE FILTER IN THAT PLACE CONDITION STR=3
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Explain usage analysis in datastage?
What are the functionalities of link partitioner?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How to reverse the string using SQL?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How to clean the datastage repository?
What is ds designer?
Explain entity, attribute and relationship in datastage?
What is use Array size in datastage
What are the job parameters?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
how to export or import the jobs in .ISX file
Define ds designer?
what is the difference between == and eq in UNIX shell scripting?
Is the value of staging variable stored temporarily or permanently?
