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 $$$$?
What is sorter transformation?
how tokens will generate?
What is the benefit of session partitioning?
Explain pushdown optimization and types in informatica
Can u generate reports in Informatica?
Write the program through which the records can be updated?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Performance tuning( what you did in performance tuning)
How to load a Dimension ? and how to load a fact table?
without table how to come first record only in oracle?
can u any challenge your project?
In informatica workflow manager, how many repositories can be created?
How do you handle two sessions in Informatica
What is informatica worklet?