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

Code check-in and check-out commands in AbInitio

0 Answers  

Have you used rollup component? Describe how.

0 Answers  

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

0 Answers  

What is sandbox?

0 Answers  

how to create a new mfs file? where will we specify the number of partition eg 4 way ,8 way?

4 Answers   IBM,

How will u remove header record? How will u remove tailer record?

5 Answers   EDS, Polaris,

What is a partition and what are the different types of partition components in abinitio?

0 Answers  

How do we handle if DML changing dynamicaly?

5 Answers   GE, HP, IBM, Mannar Company,

What is the best way of creating huge test feeds?

1 Answers  

how to insert/update a csv file by comparing it with another csv file?

0 Answers  

Can you run air sandbox run using pset ?

2 Answers  

Difference between Force_error & Force_abort?

2 Answers   Wipro,