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

In Ab Initio Join components, setting the join type to explicit allows you to configure requirements. To call the transform function for every record on in0 regardless of a match on in1, in0 must be set to required (true) and in1 to optional (false). Setting full outer join or in1 as required does not satisfy the specific requirement for in0.

Keep practicing — related questions