| |
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? |
| January 01, 2009 06:13:15 |
#4 |
| Nayak_AbIntio |
Member Since: January 2009 Total Comments: 3 |
RE: Join on partitioned flow
|
I believe "Join component expect data to be in a ordered flow if you select " Input must be sorted" as checked so that the input to JOIN will be a ordered set of data.
Then I believe the join results would be as expected.
Anyone pls comment if thinks with this the expected output wont be there and if so why? |
| |
Back To Question | |
