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.

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.

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

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

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

How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

1 Answers  

---

What are the functions of the replicate and dedup component?

1 Answers  

---

Explain what is sandbox?

1 Answers  

---

What are the primary keys and foreign keys?

1 Answers  

---

What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

1 Answers  

---

We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

1 Answers  

---

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

1 Answers  

---

What parallelisms does Abinitio support?

1 Answers  

---

Explain the methods to improve performance of a graph?

1 Answers  

---

List out the file extensions used in abinitio?

1 Answers  

---

Describe which system or process elements you would review when trouble-shooting general server slows ?

1 Answers  

---

How can you achieve scan using reformat ?

2 Answers  

---