in performance wise union is past,union all is past
- 2 Answers
- 4241 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aparna
Performance wise Union All is faster , because Union removes the duplicate records.
| Is This Answer Correct ? | 0 Yes | 0 No |
explain about lookup t/r?
What are the settings that you use to configure the joiner transformation?
how to move the mappings from your local machine to claint place?
Explain your project of banking domian.
How to load a Dimension ? and how to load a fact table?
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
what is the use of Data Mart?
What is aggregate awareness?
whats the logic to load the lower level of granularity of data to fact table.
what is parameter file?
what is work of PUSH DOWN option
What is the Difference between sorter and aggregator?
Teradata 
