how can u avoid duplicate rows in flat file?
Answer Posted / sunil
In a sorter transformation select distinct option to avoid
duplicates in a flat file
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
draw informatica architecture 8.6 ?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what is mean by complex business rule ?
Explian the Process of deployment groups in informatica
What is target designer and target load order?
What are the types of lookup transformation?
Enterprise data warehouse your projects phase by phase explain?
How would you copy the content of one repository to another repository?
Explain sql transformation in script mode examples in informatica
What is the session task and command task?
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.
Suppose we do not group by on any ports of the aggregator what will be the output?
Write the unconnected lookup syntax?
What is a predefined event?
Explain the different kinds of facts.