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
- 46898 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / nikhil sali
We can use Scan.
1) First sort your data with 2 keys dept,salary description
2) In scan create one parameter say seq nbr and initialize it with 0.
3) in scan method increment it with 1
4) this will create rank in each group of dept
5) in output select method - select record where seq_nbr = 2
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What do you mean by the overflow errors?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
What do you understand by local lookup?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
What is a partition?
What are the different types of parallelism used in abinitio?
How to create repository in abinitio for stand alone system(local nt)?
What are the functions of the replicate and dedup component?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
What exactly do you know about the typical data analysis?
How abinitio eme is segregated?
What is data encoding?
What are the steps to create a repository in ab initio?
List out the file extensions used in abinitio?
