Question
Where should a new dimension surrogate key normally be generated?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Within the controlled warehouse loading process
Explanation:
Warehouse-controlled generation keeps keys unique and independent of source systems.
It supports integration and slowly changing dimension history.
Leave a Reply