Which two steps are required to change from a normal lookup to a sparse lookup in an ODBC
Enterprise stage? (Choose two.)

A.
Sort the data on the reference link.

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

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

D.
Establish a relationship between the key field column in the source stage with the database
table field.

Explanation: