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

How you know when to use a static cache and dynamic cache in lookup transformation?

1809

list out all the transformations which use cache?

1129

Explain sessions and how many types of sessions are there?

961

How to generate or load values in to the target table based on a column value using informatica etl tool.

1031

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1736

Difference between Target-based loading and constraint-based loading?

958

where to store informatica rejected data? How to extract the informatica rejected data?

962

Explain in detail scd type 2 through mapping.

999

What is the sql query overwrite in source qualifier in informatica

1038

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1819

What is rank transform?

952

Repository user profiles

1724

What is workflow monitor?

1007

How to call shell scripts from informatica?

944

In how many ways we can create ports?

1079