Multiple choice technology

Which stage can combine db2 or Oracle database with sequential file.

  1. Join stage

  2. Merge stage

  3. Look up stage

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Lookup stage can combine data from heterogeneous sources including databases like DB2 or Oracle with sequential files. It performs reference lookups by matching key fields between the main input stream and reference data sources. Join stages require homogeneous inputs, and Merge stages only combine sorted datasets.

Keep practicing — related questions