Multiple choice technology platforms and products

9) There are two ports in0 & in1. To call transform for every record on in0 regardless of whether there is a matching record on the in1 port the options

  1. a. Set the join type as inner join

  2. b. Set the join type as explicit with require parameter true for in0

  3. c. Set the join type as explicit with require parameter true for in1

  4. d. Set the join type as full outer join
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To process every record from in0 regardless of matches on in1, set the join type to explicit with the require parameter set to true for in0. This ensures all in0 records are processed (like a left outer join behavior). Inner join would skip unmatched in0 records, requiring in1 would force in1 presence, and full outer join processes unmatched records from both ports (not specific to in0).

Keep practicing — related questions