Answer Detail: RE: Join on partitioned flow

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Print |

Question: Join on partitioned flow

Answer: If I have 2 files containing field file1(A,B,C) and file2(A,B,D), if we partition both the files on key A using partition by key and pass the output to join component, if the join key is (A,B) will it join or not and WHY?

July 07, 2008 17:00:52	#1
Puneet123	Member Since: July 2008 Total Comments: 1
RE: Join on partitioned flow
Partition component divides the data into different partitions depending upon the key. Join component expect data to be in a ordered flow if "Input must be sorted" is checked. In this case join will not going fail but it will not give the correct output.

Back To Question