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 07:10:10	#2
sixto.dsilva	CRM Expert Member Since: March 2008 Total Comments: 49
RE: Join on partitioned flow
Key is always important in Join component else you many not get the desired result.In abinitio everything is key based if the key is wrong everything can go wrong but the graph will run successfully. sometime you many not get the result atall.

Back To Question