{"id":834,"date":"2021-07-17T22:03:26","date_gmt":"2021-07-17T22:03:26","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=834"},"modified":"2021-09-11T05:17:49","modified_gmt":"2021-09-11T05:17:49","slug":"how-to-perform-database-join-with-pdi-pentaho-data-integration","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/uncategorized\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/","title":{"rendered":"How to perform database join with PDI (Pentaho Data Integration) ?"},"content":{"rendered":"<div class=\"TextHeading\">\n<div class=\"hddn\">\n<h2 id=\"database-join-with-pdi\" class=\"color-purple\" style=\"text-align: justify;\">Database join with PDI<\/h2>\n<\/div>\n<\/div>\n<div class=\"Content\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<ul>\n<li>PDI supports combination of two tables form the same database using a\u00a0<b>\u2018Table Input\u2019<\/b>\u00a0method performing the join in SQL only.<\/li>\n<li>On the other side, for joining two tables in different databases, user implement\u00a0<b>\u2018Database Join\u2019<\/b>\u00a0step.<\/li>\n<li>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<li>To avoid the above issues, there is an another option to merge rows form two different Table Input steps.<\/li>\n<li>We can also use\u00a0<b>\u2018Merge Join \u2018<\/b>step, using the SQL query having\u00a0<b>\u2018ORDER BY\u2019<\/b>\u00a0clause. Remember, the rows must be perfectly sorted before implementing merge join.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"text-center row\" style=\"text-align: justify;\">\n<div class=\"col-sm-12\">\n<div id=\"bsa-zone_1590522538159-8_123456\"><\/div>\n<\/div>\n<\/div>\n<div class=\"ImageContent\">\n<div class=\"hddn\" style=\"text-align: justify;\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/cdn.wikitechy.com\/interview-questions\/Pentaho\/pdi-join-with-database.png\" alt=\"PDI join with database\" width=\"1280\" height=\"720\" \/><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Answer : PDI supports combination of two tables form the same database using a\u00a0\u2018Table Input\u2019\u00a0method performing the join in SQL only&#8230;.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"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":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to perform database join with PDI (Pentaho Data Integration) ?<\/title>\n<meta name=\"description\" content=\"How to perform database join with PDI (Pentaho Data Integration) ? - pentaho pdi interview questions - PDI supports combination of two tables form\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to perform database join with PDI (Pentaho Data Integration) ?\" \/>\n<meta property=\"og:description\" content=\"How to perform database join with PDI (Pentaho Data Integration) ? - pentaho pdi interview questions - PDI supports combination of two tables form\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-17T22:03:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-11T05:17:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.wikitechy.com\/interview-questions\/Pentaho\/pdi-join-with-database.png\" \/>\n<meta name=\"author\" content=\"Editor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Editor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/\"},\"author\":{\"name\":\"Editor\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"headline\":\"How to perform database join with PDI (Pentaho Data Integration) ?\",\"datePublished\":\"2021-07-17T22:03:26+00:00\",\"dateModified\":\"2021-09-11T05:17:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/\"},\"wordCount\":127,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/Pentaho\\\/pdi-join-with-database.png\",\"keywords\":[\"3i Infotech Limited interview questions and answers\",\"Accenture interview questions and answers\",\"Agilis International interview questions and answers\",\"CARS24 SERV interview questions and answers\",\"CGI Group Inc interview questions and answers\",\"database join in pentaho\",\"Flipkart interview questions and answers\",\"Frequently Asked Questions Pentaho Data Integration\",\"Genpact interview questions and answers\",\"iNautix Technologies interview questions and answers\",\"Indecomm Global Services interview questions and answers\",\"JPMorgan Chase &amp; Co interview questions and answers\",\"multiway merge join pentaho\",\"pdi interview questions\",\"Pentaho BI Interview Question and Answers\",\"pentaho database join\",\"Pentaho interview question and answers\",\"Pentaho Interview Questions and Answers for freshers\",\"pentaho join\",\"pentaho join rows\",\"pentaho merge join\",\"pentaho multiway merge join\",\"pentaho report designer interview questions\",\"pentaho xml join\",\"Progressive Digital Media interview questions and answers\",\"PTC Software interview questions and answers\",\"Tata Consultancy Service interview questions and answers\",\"The Best Pentaho BI Interview Questions\",\"ValueLabs interview questions and answers\",\"What are the most important pentaho interview questions\",\"Wipro Infotech interview questions and answers\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/\",\"name\":\"How to perform database join with PDI (Pentaho Data Integration) ?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/Pentaho\\\/pdi-join-with-database.png\",\"datePublished\":\"2021-07-17T22:03:26+00:00\",\"dateModified\":\"2021-09-11T05:17:49+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"description\":\"How to perform database join with PDI (Pentaho Data Integration) ? - pentaho pdi interview questions - PDI supports combination of two tables form\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/pentaho\\\/how-to-perform-database-join-with-pdi-pentaho-data-integration\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/Pentaho\\\/pdi-join-with-database.png\",\"contentUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/Pentaho\\\/pdi-join-with-database.png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\",\"name\":\"Editor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"caption\":\"Editor\"},\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/editor\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to perform database join with PDI (Pentaho Data Integration) ?","description":"How to perform database join with PDI (Pentaho Data Integration) ? - pentaho pdi interview questions - PDI supports combination of two tables form","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/","og_locale":"en_US","og_type":"article","og_title":"How to perform database join with PDI (Pentaho Data Integration) ?","og_description":"How to perform database join with PDI (Pentaho Data Integration) ? - pentaho pdi interview questions - PDI supports combination of two tables form","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/","og_site_name":"Wikitechy","article_published_time":"2021-07-17T22:03:26+00:00","article_modified_time":"2021-09-11T05:17:49+00:00","og_image":[{"url":"https:\/\/cdn.wikitechy.com\/interview-questions\/Pentaho\/pdi-join-with-database.png","type":"","width":"","height":""}],"author":"Editor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Editor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/"},"author":{"name":"Editor","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"headline":"How to perform database join with PDI (Pentaho Data Integration) ?","datePublished":"2021-07-17T22:03:26+00:00","dateModified":"2021-09-11T05:17:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/"},"wordCount":127,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/Pentaho\/pdi-join-with-database.png","keywords":["3i Infotech Limited interview questions and answers","Accenture interview questions and answers","Agilis International interview questions and answers","CARS24 SERV interview questions and answers","CGI Group Inc interview questions and answers","database join in pentaho","Flipkart interview questions and answers","Frequently Asked Questions Pentaho Data Integration","Genpact interview questions and answers","iNautix Technologies interview questions and answers","Indecomm Global Services interview questions and answers","JPMorgan Chase &amp; Co interview questions and answers","multiway merge join pentaho","pdi interview questions","Pentaho BI Interview Question and Answers","pentaho database join","Pentaho interview question and answers","Pentaho Interview Questions and Answers for freshers","pentaho join","pentaho join rows","pentaho merge join","pentaho multiway merge join","pentaho report designer interview questions","pentaho xml join","Progressive Digital Media interview questions and answers","PTC Software interview questions and answers","Tata Consultancy Service interview questions and answers","The Best Pentaho BI Interview Questions","ValueLabs interview questions and answers","What are the most important pentaho interview questions","Wipro Infotech interview questions and answers"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/","name":"How to perform database join with PDI (Pentaho Data Integration) ?","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/Pentaho\/pdi-join-with-database.png","datePublished":"2021-07-17T22:03:26+00:00","dateModified":"2021-09-11T05:17:49+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"description":"How to perform database join with PDI (Pentaho Data Integration) ? - pentaho pdi interview questions - PDI supports combination of two tables form","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/pentaho\/how-to-perform-database-join-with-pdi-pentaho-data-integration\/#primaryimage","url":"https:\/\/cdn.wikitechy.com\/interview-questions\/Pentaho\/pdi-join-with-database.png","contentUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/Pentaho\/pdi-join-with-database.png"},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757","name":"Editor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","caption":"Editor"},"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/editor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=834"}],"version-history":[{"count":3,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/834\/revisions"}],"predecessor-version":[{"id":3263,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/834\/revisions\/3263"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}