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 / 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
How a routine is called in datastage job?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How do you reject records in a transformer?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the functionalities of link partitioner?
What are data elements?
How complex jobs are implemented in datstage to improve performance?
How the ipc stage work?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How we can covert server job to a parallel job?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Can you explain kafka connector?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
options available in sequence job to run,validate?
Name the different sorting methods in datastage.