Answer Posted / infa dev
Source and the target will the same table from which the
duplicate needs to be deleted from. Then use a lookup trans
on to this same table and then use an update trans with
DD_DELETE if the row is duplicate else do nothing.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
What is the use of an aggregator cache file?
Difference between Data and Index Caches?
How to generate sequence numbers?
what is INFORMATICA TESTING process
Separate from a database, an information bazaar, and an information stockroom?
What's the layout of parameter file (what does a parameter file contain?)?
Explain the etl program with few examples.
Explain about cumulative Sum or moving sum?
Quickly characterize reusable change?
what is informatica metadata?
What is a mapplet/worklet in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What the difference is between a database, a data warehouse and a data mart?
What is the use of transformation?
Please let me know how to make Data masking in informatica..