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
- 47383 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / vital_parsley
1)use a reformat.
2)Global variable which increments with every records only
if previous record is not equal to current record
3) output_select where sal == 2
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Describe the evaluation of parameters order in ab initio?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
How many components in your most complicated graph?
What are the factors on which storage of data depends?
Have you ever encountered an error called “depth not equal”?
What is ab initio enterprise meta>environment (eme)?
Mention what the difference between “look-up” file and “look is up” in abinitio?
What is a look-up?
Why might you create a stored procedure with the with recompile option?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What do you understand by a cartesian join?
What are the reasons for which business can trust the approach of data processing?
Have you used rollup component? Describe how.
What is the difference between a scan component and a rollup component?
State the relation between EME, GDE and Co-operating system?
