How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 45163 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
Explain about ab initio’s dependency analysis?
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 scientific data processing is different from commercial data processing?
Pdl with an example?
What are the functions of the replicate and dedup component?
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?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
What are the different types of parallelism used in abinitio?
What information is provided by .dbc file extension for connecting to the database?
Difference between output_index and output_indexes in reformat
Why do you think data processing is important?
What do you know about partition and also tell us about partition components in abinitio?
how to insert/update a csv file by comparing it with another csv file?
What do you understand by local lookup?
Describe what the SQL Server tempdb and tlog files are used for?
