How can you find the 2nd Highest salary in a file department wise in abinitio?
Answer Posted / vital_parsley
rollup would reduce the number of records how could you get
2nd highest after that ?
I think Scan can work with 2 temp vars.
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What do you understand by local lookup?
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?
How do you truncate a table?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
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
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
You can ask about different vector functions. How to use in abinitio graph?
What is m_dump?
What do you mean by the term data warehousing? Is it different from data mining?
How can a graph be run infinitely?
How do you add default rules in the transformer?
Mention how can you connect eme to abinitio server?
How does the bre work with the co>operating system?