Interested to Buy Any Domain ? << Click Here >> for more details...
what is deeup in unique only?
- 5 Answers
- 18378 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 is a data flow graph?
Hi friends, i have input like below naresh 10,20 suresh 30,40 i want out put like naresh 10 naresh 20 suresh 30 suresh 40 please help me thank you
What is dependent parameter ?
11. What is the use of allocate()?
Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...
How to move or copy the project parameter or project object to my sandbox?
What is a deadlock and how it occurs?
What is the role of co-operating system in abinitio?
Can you explain data flow graph with an example?
Have you used the rollup component? Describe how?
Difference between informatica vs ab initio?
What is air-project parameter ? How to use in abinitio graph?
3 Answers IBM, TCL, Tech Mahindra,
Teradata 
