Interested to Buy Any Domain ? << Click Here >> for more details...
what is deeup in unique only?
- 5 Answers
- 18240 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 are the different types of parallelism in ab initio?
What is a look-up?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
What is meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?
Can you explain data flow graph with an example?
what is deeup in unique only?
Do you know what a local lookup is?
In MFS i developer developed 2-way, but supporters r supporting 4-way on same records how is possible?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
What is data mapping and data modelling?
i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.
Why is data processing considered beneficial?
Teradata 
