Answer Posted / sharad sharma
The simple ligic of Union is that, It capture all the
unique recorde from bothe the source.
suppose if you have 10 records in table A and 10 records in
table B, in which 3 records are same in both the tables.
Then after using the Union transformation you will get 17
records, as the rescords which are getting duplicated will
not be in the output.
| Is This Answer Correct ? | 5 Yes | 47 No |
Post New Answer View All Answers
explain one complex mapping with logic? sales project?
What are the new features of informatica 9.x at the developer level?
How would you join a node to the already existing domain?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
can anyone explain me about retail domain project in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
what is the hint? how to use it to reduce the query processing in program?
How we can create indexes after completing the loan process?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is an unconnected transformation?
Explian the Process of deployment groups in informatica
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to extract sap data using informatica? What is abap? What are idocs?
What is Session and Batches?