Interested to Buy Any Domain ? << Click Here >> for more details...
How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 47249 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
Have you used rollup component? Describe how.
Mention what is the syntax for m_dump in abinitio?
Explain the difference between the truncate and delete commands?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What metadata importer can do in ab initio?
Have you worked with packages?
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?
How to run a graph infinitely?
Explain what does dependency analysis mean in abinitio?
How can you force the optimizer to use a particular index?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
What is the difference between look-up file and look-up, with a relevant example?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
explain checkin and checkout?
