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
Tell us about the architecture of abinitio.
Explain batch processing in ab initio?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
Why might the optimizer use a table scan when an index is available?
What are the primary keys and foreign keys?
What do you mean by a transaction file and how it is different from that of a sort file?
explain checkin and checkout?
When we should use 'jobid' for commit table (Output table component??
How does the bre work with the co>operating system?
What are the facts that can compromise data integrity?
What is abinitio?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
How data is processed and what are the fundamentals of this approach?
What exactly do you know about the typical data analysis?