How can we eliminate duplicate rows from flatfile,explain?

Question Posted / guest

3 Answers
12004 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we eliminate duplicate rows from flatfile,explain?..

Answer / nagaraj.g

using sorter transformation for distinct in a flat files

Is This Answer Correct ?

16 Yes

0 No

How can we eliminate duplicate rows from flatfile,explain?..

Answer / veera reddy

By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.

Is This Answer Correct ?

6 Yes

5 No

How can we eliminate duplicate rows from flatfile,explain?..

Answer / seshagiri

veere reddy,

Dynamic lookup will not work for flat file only static
lookup will work for a flat file

Is This Answer Correct ?

2 Yes

3 No

Post New Answer

More Informatica Interview Questions

what is the difference between Informatica 7.1 and Abinitio?

1 Answers TCS,

What does command task mean?

0 Answers

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers IBM, TCS,

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers Accenture,

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers IBM,

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers TCS,

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers

How to merge First Name & Last Name?

8 Answers

What is the query to find nth highest salary? What is the use of cursors?

8 Answers Keane India Ltd,

Can we create two repositories on same database instance in oracle?

0 Answers

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers Puma,

For more Informatica Interview Questions Click Here