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://rebrand.ly/lex-telegram-236dee

Telegram