How can we eliminate duplicate rows from flatfile,explain?

Question Posted / guest

3 Answers
11665 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

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers Wipro,

difference between repository database and repository service?

0 Answers

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers iNautix,

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers

why we use informatica in our project?

2 Answers TCS,

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers Informatica,

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers

How to handle decimal places while importing a flatfile into informatica?