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
- 47689 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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
Difference between output_index and output_indexes in reformat
Describe what the SQL Server tempdb and tlog files are used for?
What are the functions of the replicate and dedup component?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
Explain what is de-partition in abinitio?
Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low
What is a rollup component? Explain about it.
What information does a .dbc file extension provides to connect to the database?
What is ab initio enterprise meta>environment (eme)?
How co>operating system integrates with legacy codes?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What are the differences between different versions of co-op?
What are “business rules” in ab initio business rules environment (bre)?
What is a deadlock and how it occurs?
How scientific data processing is different from commercial data processing?
