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
Explain the difference between a data warehouse and a data mart?
What is the benefit of partitioning a session?
How can informatica be used for an organization?
What is a passive transformation?
During the running session, output files are created by informatica server. Enlist few of them.
On which transformations you created partitions in your project?
pmscmd startworkflow -sv
How to create or import flat file definition in to the warehouse designer?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Can you generate sequence numbers without using the sequence generator transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Which is the t/r that builts only single cache memory?
What is a router transformation?
How can we delete duplicate rows from flat files?
What is a dimensional model?