Multiple choice technology web technology

You need to do a join on 2 flows and the output should have the matching records as well as the unmatching records from In0. What type of join will you use?

  1. Inner Join

  2. Explicit Join ( record-required 0 = true, record-required 1 = true )

  3. Explicit Join ( record-required 0 = false, record-required 1 = true )

  4. Explicit Join ( record-required 0 = true, record-required 1 = false )
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The question requires a join that outputs matching records PLUS all unmatching records from In0. This is a left outer join where In0 is the left/preserved side. In AbInitio Explicit Join, record-required 0=false means In0 records are preserved even without matches, and record-required 1=true means In1 records require matches. Option C correctly shows this configuration: (record-required 0=false, record-required 1=true). Option A is inner join (both required). Option B requires matches from both sides. Option D would preserve In1, not In0.

Keep practicing — related questions