How to eliminate duplicates in FF and oracle both
Answer Posted / priyank
For FF, place an Aggregator transformation, do a group by
on all the columns, it will remove the duplicates from the
flat file.
In Oracle, use distinct in SQ sql override to remove the
duplicates.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is workflow manager?
How to create a non-reusable instance of reusable transformations?
tell me 5 session failure in real time how can you solve that in your project?
What is incremental aggregation?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain what are the different versions of informatica?
What are junk dimensions?
How can you increase the performance in joiner transformation?
How many numbers of sessions can one group in batches?
What are the different types of repositories created using informatica?
Implementation methodology
What are the mapping parameters and mapping variables?
Explain the difference between a data warehouse and a data mart?
What are the new features of Power Center 5.0?
What does update strategy mean, and what are the different option of it?