GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Abinitio
Go To First  |  Previous Question  |  Next Question 
 Abinitio  |  Question 186 of 193    Print  
Join on partitioned flow
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?


  
Total Answers and Comments: 3 Last Update: August 13, 2008     Asked by: abinitio17 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 01, 2008 17:00:52   #1  
Puneet123 Member Since: July 2008   Contribution: 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.
 

 
Is this answer useful? Yes | No
July 24, 2008 07:10:10   #2  
sixto.dsilva Member Since: March 2008   Contribution: 50    

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.


 
Is this answer useful? Yes | No
August 13, 2008 05:41:59   #3  
srinivas.rao.etl Member Since: August 2008   Contribution: 2    

RE: Join on partitioned flow

.dbc : Database Connectivity - In input table specify db version, host location, user name, password etc.

.cfg : Server Connectivity


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape