in performance wise union is past,union all is past
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 |
what is confirmed fact?
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
how i will stop my workflow after 10 errors
How can we improve session performance in aggregator transformation?
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
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?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
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???
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