How can we eliminate duplicate rows from flatfile,explain?

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 procedure for creating independent data marts from informatica 7.1?

0 Answers  


What is the difference between Active and Passive transformation?

0 Answers   Informatica,


Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,


Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,


If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,


How can we use mapping variables in informatica? Where do we use them?

0 Answers  


How would you copy the content of one repository to another repository?

0 Answers  


followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,


Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  


Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,


what transformations are used for Variable port?

2 Answers  


what are testing in a mapping level please give brif eplanation

1 Answers   CTS,


Categories