IBM
C2090-552 · Question #113
You are using the Hash_Lookup function and errors occur that indicate records are not found in the Lookup Table. What is the cause of this problem?
The correct answer is B. The key field in the lookup table that contains the sequence numbers has gaps in those. See the full explanation below for the reasoning.
Question
You are using the Hash_Lookup function and errors occur that indicate records are not found in the Lookup Table. What is the cause of this problem?
Options
- AThe lookup table is too small in relationship to the number of records in the source
- BThe key field in the lookup table that contains the sequence numbers has gaps in those
- CThis error could not occur, Hash_Lookup will always return a row from the lookup table.
- DA memory error has occurred and the Optim process must be restarted.
How the community answered
(16 responses)- A13% (2)
- B75% (12)
- C6% (1)
- D6% (1)
Community Discussion
No community discussion yet for this question.