How can you find the 2nd Highest salary in a file department wise in abinitio?
Answer Posted / roshni
you can use roll up to calculate dept wise salary first and
then sort it with key as sal. create indexes using
next_in_sequence() and then filter out the 2nd record.
hope this helped!!
Is This Answer Correct ? | 19 Yes | 11 No |
Post New Answer View All Answers
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
what is the project environment(for each project the environment is same or different to different project)?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
What is the function that transfers a string into a decimal?
Describe the evaluation of parameters order in ab initio?
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?
What do you mean by data sorting?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
What is publickey and private key?what is the use of this two keys?
What are the types of data processing you are familiar with?
What is a look-up?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
What are the features of ab initio?
What are the six data process products of ab initio (architecture of ab initio)?