Abinitio - How to separate duplicate records with out Dedup sorted from the grouped input file?

GeekInterview.com > Tech FAQs > Abinitio

Go To First | Previous Question | Next Question

Abinitio | Question 20 of 26

How to separate duplicate records with out Dedup sorted from the grouped input file?

Total Answers and Comments: 3

Last Update: June 25, 2008 Asked by: anji_abinitio

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 13, 2007 02:43:58

mailme_varma

Member Since: December 2007 Contribution: 1

RE: How to separate duplicate records with out Dedup sorted from the grouped input file?

in.* Rollup

Is this answer useful? Yes | No

December 31, 2007 01:54:33

surabhiraghu

Member Since: December 2007 Contribution: 11

RE: How to separate duplicate records with out Dedup sorted from the grouped input file?

with help roolup component functions like last, first

Is this answer useful? Yes | No

June 25, 2008 09:08:54

sixto.dsilva

Member Since: March 2008 Contribution: 23

RE: How to separate duplicate records with out Dedup sorted from the grouped input file?

you can use rollup to remove a duplicate record in a input file(note that it is key based duplicate), it will keep the last record based on that key.

Is this answer useful? Yes | No