How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 42476 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
How you can run a graph infinitely in ab initio?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
Explain what is the architecture of abinitio?
How abinitio eme is segregated?
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
What do you mean by the term data warehousing? Is it different from data mining?
What are the six data process products of ab initio (architecture of ab initio)?
What are the features of ab initio?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
How many components in your most complicated graph?
What are the types of data processing you are familiar with?
Explain about ab initio’s dependency analysis?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
What are the key elements of a data processing system?
Mention what is abinitio?
