| |
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? |
| March 03, 2009 11:04:36 |
#6 |
| Subhra Dhar |
Member Since: March 2009 Total Comments: 3 |
RE: Join on partitioned flow
|
| I do not think the join output would be correct. The partition key fields for the two input streams should be same as the join key fields in the join component, otherwise the data from stream 1 would be partitioned in a different way than data from stream 2 and won't find all matches in the join component. |
| |
Back To Question | |
