what is deeup in unique only?
- 5 Answers
- 16110 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 information does a .dbc file extension provides to connect to the database?
How does the bre work with the co>operating system?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
Layout - L1*, L1 - What is the difference ? How to use in abinitio graph?
What is the architecture of abinitio?
If you check in one file twice in EME, one with a tag and second without a tag - Will the version number change ? How to use in abinitio graph?
Explain the methods to improve the performance of a graph?
name the air commands in ab initio?
explain the environment varaibles with example?
What is difference between API
2 Answers CitiGroup, IBM, TCL,
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
) Diff.between Output index and Output indexes?
Teradata 
