in performance wise union is past,union all is past
Answer Posted / jz
Performance wise Union all is Fast.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the reusable transformations?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what is the hint? how to use it to reduce the query processing in program?
What are the guidelines to be followed while using union transformation?
Describe expression transformation?
What is meant by target load plan?
What is informatica etl tool?
What are roles and groups and benefits of using them?
what is song in infrmatica...?
Parameter and variable differences
Describe an informatica powercenter?
What is the fact table?
How many ways a relational source definition can be updated and what are they?
What do think which one is the better joiner or look up?
What if the source is a flat-file?