Database join with PDI<\/h2>\n<\/div>\n<\/div>\n

\n

\n

\n
• PDI supports combination of two tables form the same database using a\u00a0\u2018Table Input\u2019<\/b>\u00a0method performing the join in SQL only.<\/li>\n
• On the other side, for joining two tables in different databases, user implement\u00a0\u2018Database Join\u2019<\/b>\u00a0step.<\/li>\n
• Though in database join, each input row query executes on the target system from the main stream, ensuing in lower performance as the number of queries implement on the B increases.<\/li>\n
• To avoid the above issues, there is an another option to merge rows form two different Table Input steps.<\/li>\n
• We can also use\u00a0\u2018Merge Join \u2018<\/b>step, using the SQL query having\u00a0\u2018ORDER BY\u2019<\/b>\u00a0clause. Remember, the rows must be perfectly sorted before implementing merge join.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
  \n

  \n

  <\/div>\n<\/div>\n<\/div>\n

  \n

  <\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

  Answer : PDI supports combination of two tables form the same database using a\u00a0\u2018Table Input\u2019\u00a0method performing the join in SQL only….<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[1],"tags":[5432,195,5431,5433,214,5589,222,5487,484,5428,212,973,5588,5485,5407,5584,5425,5408,5583,5586,5587,5585,5484,5590,5429,5430,975,5486,284,5406,968],"class_list":["post-834","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-3i-infotech-limited-interview-questions-and-answers","tag-accenture-interview-questions-and-answers","tag-agilis-international-interview-questions-and-answers","tag-cars24-serv-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-database-join-in-pentaho","tag-flipkart-interview-questions-and-answers","tag-frequently-asked-questions-pentaho-data-integration","tag-genpact-interview-questions-and-answers","tag-inautix-technologies-interview-questions-and-answers","tag-indecomm-global-services-interview-questions-and-answers","tag-jpmorgan-chase-and-go-interview-questions-and-answers","tag-multiway-merge-join-pentaho","tag-pdi-interview-questions","tag-pentaho-bi-interview-question-and-answers","tag-pentaho-database-join","tag-pentaho-interview-question-and-answers","tag-pentaho-interview-questions-and-answers-for-freshers","tag-pentaho-join","tag-pentaho-join-rows","tag-pentaho-merge-join","tag-pentaho-multiway-merge-join","tag-pentaho-report-designer-interview-questions","tag-pentaho-xml-join","tag-progressive-digital-media-interview-questions-and-answers","tag-ptc-software-interview-questions-and-answers","tag-tata-consultancy-service-interview-questions-and-answers","tag-the-best-pentaho-bi-interview-questions","tag-valuelabs-interview-questions-and-answers","tag-what-are-the-most-important-pentaho-interview-questions","tag-wipro-infotech-interview-questions-and-answers"],"yoast_head":"\n