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
What is the Rank index port in Rank transformation?
Under which circumstances, informatica server creates reject files?
What is the use of transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is joiner transformation in informatica?
design of staging area?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Is stop and abort are same in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
How to improve the performance of a session using sorter transformation?
What is status code in informatica?
How to join three sources using joiner? Explain though mapping flow.
How many types of sessions are there in informatica.please explain them?
What is a connected transformation?