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

in performance wise union is past,union all is past

Question Posted / aparna

Answer Posted / aparna

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the types of data warehouses?

1499

What is event and what are the tasks related to it?

1102

EXL informatica Questions

1359

What is a connected transformation?

1097

Explain how to import oracle sequence into informatica?

989

list out all the transformations which use cache?

1167

How many input parameters can exist in an unconnected lookup?

1531

Clarify the aggregator change?

1012

How to update or delete the rows in a target, which do not have key fields?

1166

What are batches?

1077

State the differences between sql override and lookup override?

1177

Differentiate between source qualifier and filter transformation?

1564

How big was your fact table

1785

What are active transformations.

1639

What is an expression transformation in informatica?

1007