How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
Answer Posted / guest
Frist using Sortstage sort the records based on sal column
for desc order and Each record unqiely identify using
surogatekey after that filterstage filter the first record
based on sur column and drag and drop only in sal column
in the output.Then We get the Max sal
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between odbc and drs stage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the different options associated with dsjob command?
Define Merge?
what is the use of skid in reporting?
root tree will find which is server job and which is parallel job?
What are the some differences between 7.x and 8.x version of datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the partitioning techniques available in link partitioner?
How complex jobs are implemented in datstage to improve performance?
What are stage variables?
How many types of hash files are there?
which r the connectors used in san?
Explain datastage architecture?