in performance wise union is past,union all is past




Answers were Sorted based on User's Feedback



in performance wise union is past,union all is past ..

Answer / jz

Performance wise Union all is Fast.

Is This Answer Correct ?    4 Yes 0 No

in performance wise union is past,union all is past ..

Answer / aparna

Performance wise Union All is faster , because Union removes the duplicate records.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is confirmed fact?

2 Answers  


insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  


how i will stop my workflow after 10 errors

1 Answers   HP,


How can we improve session performance in aggregator transformation?

0 Answers   Informatica,


how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,






what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,


If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,


How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,


hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,


How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,


Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,


Categories