in performance wise union is past,union all is past
Answer Posted / aparna
Performance wise Union All is faster , because Union removes the duplicate records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How would you copy the content of one repository to another repository?
design of staging area?
Clarify the utilization of aggregator cache record?
Explain how to import oracle sequence into informatica?
What are the differences between source qualifier and joiner transformation?
What is the meaning of decode in informatica?
Define pmcmd command?
What is workflow? What are the components of the workflow manager?
Explain transaction control transformation in informatica
What is an Integration service in Informatica?
What are some examples of informatica etl programs?
What is persistent lookup cache?
What is mapplet in informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is a dimensional model?