Answer Posted / amedela chandra sekhar
Union it support only same metadata in both the tables.
it will execute same metadata.
it means reject the unmatched data.
so reject some records.
so it changes the no of records
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
What happens when a session fails and you click on recover?
What is a node in Informatica?
what is Active lock explain
Explain constraint based loading in informatica
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
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 do you mean by filter transformation?
How can you validate all mappings in the repository simultaneously?
What is DR strategy for Informatica project?
How to extract the informatica rejected data?
If informatica has its scheduler why using third party scheduler?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to extract sap data using informatica? What is abap? What are idocs?
What is rank transformation in informatica
What is a grid in Informatica?