Answer Posted / mahendra garewal
Your result will come as per you specify the first/last
record. as it does not sort the records.
ex:
Input
A B C
----------
1 a d
4 f h
6 y g
7 g u
2 i o
Output
a: if selected first record in dedup
A B C
----------
1 a d
b: if selected last record in dedup
A B C
----------
2 i o
headers and trailers are processed like this only.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What are “business rules” in ab initio business rules environment (bre)?
What is publickey and private key?what is the use of this two keys?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
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?
What does it mean by the term 'sort component'?
What is de-partition in abinitio?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
How is the partitioning with key different from round robin partition?
What a local lookup is?
What information is provided by .dbc file extension for connecting to the database?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
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 the difference between partitioning with key / hash and round robin?
What are the co> operating system’s assorted library of integrated components?
