Interested to Buy Any Domain ? << Click Here >> for more details...
in performance wise union is past,union all is past
- 2 Answers
- 5304 Views
- I also Faced
- E-Mail Answers
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 can we remove the duplicates from flat file source?
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?
Performance tuning in UNIX for informatica mappings?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How do you take back up of repository?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What all join we can perform in LOOKUP transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
what are the Methods For Creating Reusable Transformations?
Explain the types of transformations?
What is the advantage of informatica?
How can we store previous session logs?
How many transformations can be used in mapplets.
What is workflow monitor?
What is the meaning of up gradation of repository?
