hard20 pts · first answer countsdata-modellingkeys

Rebuilding a dimension renumbered keys

A full refresh rebuilds dim_product with ROW_NUMBER() as its surrogate key. Next morning, sales show the wrong products. Why?

A.ROW_NUMBER() cannot create unique valuesB.Facts must store product names rather than surrogate keysC.The dimension needs more partitionsD.Keys were renumbered, so old fact keys hit other rows

Discussion 0

Join free to post in the discussion.

Rebuilding a dimension renumbered keys

Discussion 0

Related questions