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

What is confirmed fact in dataware housing?

6184


In informatics server which files are created during the session rums?

840


Explain incremental aggregation in informatica

850


Why is sorter an active transformation?

865


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1384


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10434


State the differences between sql override and lookup override?

838


What is a router transformation?

809


What are batches?

802


What is informatica?

860


What is complex mapping?

853


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. ?

1787


Target increases every day even though no new record was inserted

1322


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1022


draw informatica architecture 8.6 ?

3629