in performance wise union is past,union all is past

Question Posted / anu63.p

2 Answers
5400 Views
I also Faced
E-Mail Answers

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

task is running successfully but data is not loded why?

2 Answers

How to use pmcmd utility command?

0 Answers

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers CTS, Symphony,

What is DTM process?

4 Answers

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers Cegedim,

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers Nationwide,

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers Target,

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers IBM, Infotech,

Can we create multiple integration service on single repository?

0 Answers

For more Informatica Interview Questions Click Here