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
- 47248 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
What information does a .dbc file extension provides to connect to the database?
How to add default rules in the transformer?
Mention what dedup-component and replicate component does?
Describe what the SQL Server tempdb and tlog files are used for?
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
Tell us about the architecture of abinitio.
Have you worked with packages?
What metadata importer can do in ab initio?
What is the function that transfers a string into a decimal?
Describe the evaluation of parameters order in ab initio?
Mention what is the syntax for m_dump in abinitio?
How to move or copy the project parameter or project object to my sandbox?
What dedup-component and replicate component does?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
What is abinitio?
