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

Answer Posted / kiran

We can use dynamic cache in lookup to eliminate duplicates.

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use pmcmd utility command?

582


What are the different transaction levels available in transaction control transformation?

675


What is an expression transformation?

594


Design time, run time. If you don't create parameter what will happen

1428


Make a note of the quantity vaults made in informatica?

558






What is the way to execute pl/sql script using informatica mapping?

962


What is a predefined event?

660


What is rank transform?

601


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

675


How to configure mapping in informatica?

674


Explain the shared cache and re-cache?

613


Different sorts of metadata that stores in the storage facility?

561


Differentiate between a repository server and a powerhouse?

577


how to create user defined function (udf) in informatica

785


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1604