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 different ways to implement parallel processing in informatica?

1425

Define Pmrep command?

1067

What is aggregator transformation in informatica?

953

Define update strategy?

1233

What do you mean by worklet?

1071

What you know about transaction control transformation?

996

Briefly define reusable transformation?

1133

What is status code in informatica?

1024

COM components can be used in Informatica

2395

What is data transformation manager process?

1165

Explain how many types of dimensions are available in informatica?

1098

What is a stored procedure transformation?

1056

Differentiate between Load Manager and DTM?

2160

in reporting we add some new objects,how we get the count of the newly added objects to the report

2200

What does cheating measurement mean?

1065