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 tuning techniques you applied during your last project

2040

What do you mean by blocking transformation?

1055

What is persistent lookup cache?

1039

Describe the impact of several join conditions and join order in a joiner transformation?

1068

Where do we use mapping variables in informatica?

1080

How many ways are there to create ports?

1345

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4120

expain about the tune parameters?

2422

hi real timers . iam waiting for ur reply regarding ETL TESTING

2283

How are indexes created after completing the load process?

1659

if we have a delimiters at unwanted places in a flat file how can we over come those.

2053

What is workflow? What are the components of the workflow manager?

1152

What are junk dimensions?

1081

What is a passive transformation?

1115

During the running session, output files are created by informatica server. Enlist few of them.

993