Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7377 Views
- CSC, I also Faced
- E-Mail Answers
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
Does an informatica transformation support only aggregate expressions?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Have you worked with/created Parameter file
Differentiate between router and filter transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How to implement security measures using repository manager?
What is aggregator transformation in informatica?
What is the sql query overwrite in source qualifier in informatica
What is fact table? Explain the different kinds of facts.
What is meant by query override?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How can we store previous session logs?
What could be the possible resons of locks by user?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Write the unconnected lookup syntax?
