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
can you please explain me pre session and post session options?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Please let me know how to make Data masking in informatica..
What is informatica? Why do we need it?
Why do we need informatica?
What is the use of code page?
What are the different ways to implement parallel processing in informatica?
How does the aggregator transformation handle null values?
What are ETL Tools?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How can you validate all mappings in the repository simultaneously?
How many number of sessions can one group in batches?
Where do we use mapping variables in informatica?
How can repository reports be accessed without sql or other transformations?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica