We can use dynamic cache in lookup to eliminate duplicates.

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

Question Posted / kiran

Answer Posted / kiran

Is This Answer Correct ?

11 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the informatica workflow?

1081

Explain the types of transformations?

1078

What is meant by pre and post session shell command?

1169

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

1134

tell me 5 session failure in real time how can you solve that in your project?

2310

Where can we find the throughput option in informatica?

1072

Explain informatica architecture - version 8 / 9

1102

Explain the difference between mapping parameter and mapping variable?

1053

What are the types of presistent cache in look up tr.

2064

Write the unconnected lookup syntax and how to return more than one column.

1120

What do you mean incremental aggregation?

1089

Differentiate between source qualifier and filter transformation?

1586

How can we remove the duplicates from flat file source?

1049

I have a flat file, want to reverse the contents of the flat file

1135

Make a note of the quantity vaults made in informatica?

997