what is deeup in unique only?

Answer Posted / mahesh

dedup is used to fetch or forward a unique row of many.
It has options of first ,last and unique only.
If you sort the dataset you can select exactly which row to
forward of may rows.

first - fwds first of many rows
last - fwds last of many rows
unique only - fwds rows which just have one entry.i.e no
rows which have dups

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the kinds of layouts does ab initio supports?

578


Describe the evaluation of parameters order in ab initio?

964


What is a local lookup?

692


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?

3899


Suppose you find the term validation mentioned with a set of data, what does that simply represent?

585






What are the steps to create a repository in ab initio?

756


What are the key elements of a data processing system?

692


How can we increase the loading performance of oracle table in AbInitio?

640


What do you mean by a transaction file and how it is different from that of a sort file?

632


Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

862


How abinitio eme is segregated?

805


What are the facts that can compromise data integrity?

629


What is local and formal parameter?

772


What are the Types of parallelism in detail?

705


What does it mean by the term 'sort component'?

678