Difference Between Union All And Merge Join?

1.	Difference Between Union All And Merge Join?
Answer» a) Merge transformation can accept only two inputs whereas Union all can take more than two inputs B) DATA has to be sorted before Merge Transformation whereas Union all doesn't have any condition LIKE that. a) Merge transformation can accept only two inputs whereas Union all can take more than two inputs b) Data has to be sorted before Merge Transformation whereas Union all doesn't have any condition like that.

Answer»

a) Merge transformation can accept only two inputs whereas Union all can take more than two inputs

B) DATA has to be sorted before Merge Transformation whereas Union all doesn't have any condition LIKE that.

a) Merge transformation can accept only two inputs whereas Union all can take more than two inputs

b) Data has to be sorted before Merge Transformation whereas Union all doesn't have any condition like that.

Discussion