Types of lookup in parallel?
-
Normal
-
Sparse
-
Both
-
None of the Above
C
Correct answer
Explanation
DataStage supports two types of lookup in parallel jobs: Normal lookup (loads entire reference dataset into memory) and Sparse lookup (queries the database for each key value). Both are valid approaches depending on your data volume and performance requirements.