in performance wise union is past,union all is past

Question Posted / anu63.p

2 Answers
5313 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

What is sorter transformation?

0 Answers

Tell me one complex query in oracle ?

2 Answers L&T, Satyam,

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers TCS,

Is it possible to revert a global repository to local one and why?

0 Answers

in oracle write query yourname+1 from dual

5 Answers

Does Facttable Normalized or Denormalized?

2 Answers IBM,

Explain the informatica workflow?

0 Answers

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers IBM, Polaris,

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers

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

0 Answers

waht is dataware house

2 Answers

Could any one to tell Fact table Partitioning?

2 Answers

For more Informatica Interview Questions Click Here