1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How can we eliminate duplicate rows from flatfile,explain?

Question Posted / guest

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

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

List the transformation in informatica.

1 Answers   TCS,

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  




I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,

How to delete duplicate record in Informatica?

7 Answers  

For more Informatica Interview Questions Click Here
Categories