Informatica - hwo can we eliminate duplicate rows from flat file?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 276 of 631

hwo can we eliminate duplicate rows from flat file?

Total Answers and Comments: 8

Last Update: June 23, 2006 Asked by: kishore

Sponsored Links

Best Rated Answer

—

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

May 22, 2006 04:26:30

Karthikeya

RE: hwo can we eliminate duplicate rows from flat file...

keep aggregator between source qualifier and target and choose group by field key, it will eliminate the duplicate records.

Is this answer useful? Yes | No

May 22, 2006 05:18:38

Nanda Kumar

RE: hwo can we eliminate duplicate rows from flat file...

Hi , Before loading to target , use an aggregator transformation and make use of group by function to eleminate the duplicates on columns .Nanda

Is this answer useful? Yes | No

May 22, 2006 05:22:31

Sudhakar Reddy

RE: hwo can we eliminate duplicate rows from flat file...

Use Sorter Transformation. When you configure the Sorter Transformation to treat output rows as distinct, it configures all ports as part of the sort key. It therefore discards duplicate rows compared during the sort operation

Is this answer useful? Yes | No

May 22, 2006 05:29:07

nan.kumar

Member Since: May 2006 Contribution: 2

RE: hwo can we eliminate duplicate rows from flat file...

Hi, Before loading to target Use an aggregator transformation and use group by clause to eliminate the duplicate in columns.Nanda

Is this answer useful? Yes | No

May 25, 2006 09:26:21

afzal pathan

RE: hwo can we eliminate duplicate rows from flat file...

Use sorter transformation ,select distinct option ,duplicate rows will be eliminated.

Is this answer useful? Yes | No

May 27, 2006 11:53:43

srinivasgogineni

RE: hwo can we eliminate duplicate rows from flat file...

if u want to delete the duplicate rows in flat files then we go for rank transformation or oracle external procedure tranfornation

select all group by ports and select one field for rank,its easily dupliuctee now

Is this answer useful? Yes | No

June 13, 2006 05:32:49

sai

RE: hwo can we eliminate duplicate rows from flat file...

using Sorter Transformation we can eliminate the Duplicate Rows from Flat file

Thanks

N.Sai

Is this answer useful? Yes | No

June 23, 2006 02:17:37

mootati raghavendroa reddy

RE: hwo can we eliminate duplicate rows from flat file...

to eliminate the duplicate in flatfiles, we have distinct property in sorter transformation. If we enable that property, automatically it will remove duplicate rows in flatfiles.

Is this answer useful? Yes | No

Go To Top