You have a 3TB dataset hash-partitioned on CustID in a clustered environment. You need to join
this dataset with 1GB of reference data on OrderID. Which technique is most appropriate?

A.
Use Lookup stage,select auto partitioning for both link.

B.
Use Join stage,hash-partition and sort both link on OrderID.

C.
Use Lookup stage,select auto partitioning for the stream link and entire partitioning for the
reference link.

D.
Use Lookup stage,select auto partitioning for the stream link and hash-partition the reference
link on CustID.

Explanation: