Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7076 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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to extract the informatica rejected data?
Which transformation should we use to normalise the COBOL and relational sources?
Define enterprise data warehousing?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What happens when a session fails and you click on recover?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to create the source and target database connections in server manager?
Explain the types of lookup transformation?
Can u generate reports in Informatica?
Describe expression transformation?
Why is sorter an active transformation?
Explain what is informatica metadata and where is it stored?
How can you generate reports in informatica?
What are the different ways to implement parallel processing in informatica?
