Multiple choice technology databases

What are the join stages available in lookup stage?

  1. LeftOuter Join,Right Outer Join,Inner join

  2. Outer Join,Inner Join

  3. Left Outer Join,Inner Join

  4. Left Outer Join,Right Outer Join
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The DataStage Lookup stage supports two join types: Inner Join (only matching records) and Left Outer Join (all records from left stream, matching from right). Right Outer Join is not supported because the lookup is always from the input stream to the reference dataset.

Keep practicing — related questions