IBM
C2090-303 · Question #24
Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?
The correct answer is C. Change the lookup option in the stage properties to "Sparse". See the full explanation below for the reasoning.
Question
Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?
Options
- AChange the partitioning to hash.
- BSort the data on the reference link.
- CChange the lookup option in the stage properties to "Sparse".
- DReplace columns at the beginning of a SELECT statement with a wildcard asterisk (*).
How the community answered
(45 responses)- A11% (5)
- B7% (3)
- C78% (35)
- D4% (2)
Community Discussion
No community discussion yet for this question.