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?

A.
The lookup table is too small in relationship to the number of records in the source database table consequently more records need to be added to the lookup table.

B.
The key field in the lookup table that contains the sequence numbers has gaps in those sequence numbers.

C.
This error could notoccur, Hash_Lookup will always return a row from the lookup table.

D.
A memory error has occurred and theOptim process must be restarted.