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?

Question

Options

• AThe lookup table is too small in relationship to the number of records in the source database table
• BThe key field in the lookup table that contains the sequence numbers has gaps in those sequence
• 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.

• A
  5% (1)
• B
  81% (17)
• C
  10% (2)
• D
  5% (1)

No community discussion yet for this question.