How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 42479 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / nikhil sali
We can use Scan.
1) First sort your data with 2 keys dept,salary description
2) In scan create one parameter say seq nbr and initialize it with 0.
3) in scan method increment it with 1
4) this will create rank in each group of dept
5) in output select method - select record where seq_nbr = 2
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Difference between output_index and output_indexes in reformat
How co> operating system natively processes the data?
What are the different types of parallelism used in abinitio?
How do you improve the performance of a graph?
What is the function that transfers a string into a decimal?
How to compare two dmls in abinitio
What do you understand by a cartesian join?
How you can run a graph infinitely in ab initio?
What is the difference between partitioning with key / hash and round robin?
Mention what is rollup component?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
How can you force the optimizer to use a particular index?
Give one reason when you need to consider multiple data processing?
What is m_dump?
