⟩ Can a dimension table contain numeric values?
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.
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.
What is database partitioning?
How to enable partition support for a database?
Explain What is the advantages data mining over traditional approaches?
Explain the main differences between star and snowflake schema?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What are the main steps to build the data warehouse?
Explain the different types of data warehousing?
Explain What are Fact, Dimension, and Measure?
Explain What is a cube in data warehousing concept?
Why fact table is in a normal form?