Data Warehousing Basics Question:

Explain can a dimension table contains numeric values?

Basics Data Warehouse Interview Question
Basics Data Warehouse Interview Question

Answer:

Yes dimension can have numeric values, that is surrogate Key which holds numeric value for unique identification of records in the dimension


Previous QuestionNext Question
Explain Dimensional Modelling?Explain the difference between view and materialized view?