what is deeup in unique only?
- 5 Answers
- 16130 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prashant jaiswal
To explain with example, If you have 10 records with dedupe
key having values of 10,10,20,30,30,30,30,40,40,50. On
deduping UNIQUE, you will get 20 & 50 in your output.
Remaning records comes out in the dup port.
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / dhirendra
keep Parameter of Dedup Sorted Component
(choice, required)
Specifies which records the component keeps to write to the
out port. Choose one of the following options:
first — Keeps the first record of a group
last — Keeps the last record of a group
unique-only — Keeps only records with unique key values
The component writes the remaining records of each group to
the dup port.
Default is first.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / raju mortale
Dudup Sorted is use to remove the duplicates from records.
There is one keep parameter choices are [first,lastand unique ]
give sorted input to dudup for better result.
EX....
ID Name
1,abc
3,bcd
1,dhrf
4,dgd
2,dgf
1,dgd
2,cbdg
when you keep parameter set to unique and key is id then it will return unique only
ID Name
3,bcd
4,dgd
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / 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 |
What is the function you would use to transfer a string into a decimal?
Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?
the inputs are 10,20,30,40,50 but the output was comes 0 records,the graph was failed what is bad situation?
What does dependency analysis mean in Ab Initio?
what are kinds of layouts does ab initio supports ?
Have you ever encountered an error called “depth not equal”?
what is different daily and monthly develop the abinitio graphs?
How to load the data from an excel sheet to input file in a graph?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
Give one reason when you need to consider multiple data processing?
What is the syntax for m_dump in abinitio?
What the difference between “look-up” file and “look is up” in abinitio?
Teradata 
