You have sales order data in SaleOrders.xls and product details in Product.xls. Which join type will you use to return rows from the second source, with empty values for non-matching keys in the first data stream?

LEFT OUTER
RIGHT OUTER
FULL OUTER
INNER
Verified Answer
Correct Option - b

To get all Infosys Certified Pentaho Data Integration Developer Exam questions Join Telegram Group https://bit.ly/infy_premium_group

Telegram

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in

Updated on Sun, 1 Jun 2025