How can you find the 2nd Highest salary in a file department wise in abinitio?
Answer Posted / vital_parsley
rollup would reduce the number of records how could you get
2nd highest after that ?
I think Scan can work with 2 temp vars.
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
Runtime behavior of Normalize and Reformat
I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
List out the file extensions used in abinitio?
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 ?
When we should use 'jobid' for commit table (Output table component??
Is data warehousing different from data mining?
What are the six data process products of ab initio (architecture of ab initio)?
How you can run a graph infinitely in ab initio?
What is the role of co-operating system in abinitio?
explain the environment varaibles with example?
What do you mean by the term data warehousing? Is it different from data mining?
How data is processed and what are the fundamentals of this approach?