easy5 pts · first answer countsdata-pipelinesdata-modeling

Why a dimension has its own key

The source customer_id is CUST-1001. Why does the warehouse dimension also add a surrogate key like customer_sk = 58213?

A.Surrogate keys make tables smaller on disk onlyB.Source ids are not allowed in warehousesC.It lets one customer have several history rowsD.It hides the customer from analysts

Discussion 0

Join free to post in the discussion.

Why a dimension has its own key

Discussion 0

Related questions