Data Warehousing Question:

Can a dimension table contain numeric values?

Data Warehousing Interview Question
Data Warehousing Interview Question

Answer:

Yes. However, those data type will be char (only the values can numeric/char).Yes, dimensions even contain numerical because these are descriptive elements of our business.


Previous QuestionNext Question
What is hybrid slowly changing dimension?How do you create Surrogate Key using Ab Initio?