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
- 47372 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
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
Can sorting and storing be done through single software or you need different for these approaches?
Mention what is abinitio?
Explain how you can run a graph infinitely in ab initio?
What do you mean by the overflow errors?
How is the partitioning with key different from round robin partition?
Is data warehousing different from data mining?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
To which project that prefix will set is to private project or public project or both?how and where to set?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What information does a .dbc file extension provides to connect to the database?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
What is rollup component?
