Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector
stage?

A.
Change the partitioning to hash.

B.
Sort the data on the reference link.

C.
Change the lookup option in the stage properties to “Sparse”.

D.
Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).

Explanation: