Answer Posted / hari babu
In JOIN component : Dedup pareametr set to TRUE that means
to remove dulicate ecords from the input port before JOIN.
BY EFAULT : FALS.
DEDUP SORT COMPONENT: It separates one specified record in
each group of records .
This component reqired grouped input.
Keep Parametr: we set below optiones.
1.first — Keeps the first record of a group
2.last — Keeps the last record of a group
3.unique-only — Keeps only records with unique key values
Default is first
Thx
Hari Babu
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you know what a local lookup is?
What do you understand by a cartesian join?
Where $mpjret is used in ab-initio?
When we should use 'jobid' for commit table (Output table component??
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 is the purpose of having stored procedures in a data-based?
What is the difference between look-up file and look-up, with a relevant example?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What do you mean by the term data warehousing? Is it different from data mining?
How can you force the optimizer to use a particular index?
What is broadcasting and replicate?
How co> operating system natively processes the data?
how to insert/update a csv file by comparing it with another csv file?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
Do you think effective communication is necessary for data processing? What is your strength in terms of same?