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
how to insert/update a csv file by comparing it with another csv file?
what is the output when -1 is put in select_expr of FBE?
Within a cursor, how would you update fields on the row just fetched?
What is the purpose of having stored procedures in a data-based?
Mention what information does a .dbc file extension provides to connect to the database?
Explain what is sort component in abinitio?
What are the benefits of data analyzing?
Explain the difference between the truncate and delete commands?
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
How many components in your most complicated graph?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
What are the Types of parallelism in detail?
How do you add default rules in the transformer?
What is ab initio enterprise meta>environment (eme)?
What are “business rules” in ab initio business rules environment (bre)?