Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates in FF and oracle both
- 3 Answers
- 7100 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 to Create a folder using pmrep command?
Explain informatica architecture - version 8 / 9
What is decode in static cache?
Explain the different lookup methods used in informatica?
What is the Process to creating lookup transformation in informatica
What is the difference between router and filter?
Explain pmcmd command usage in informatica
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the mapping parameters and mapping variables?
What do you understand by term role-playing dimension?
wf dont have integration severances how you can run?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
how tokens will generate?
As union transformation gives UNION ALL output, how you will get the UNION output?
