A ________ is a dimension table that contains hierarchies, such as time, geography, or product.
- Conformed dimension
- Degenerate dimension
- Hierarchical dimension
- Role-playing dimension
A Role-playing dimension is a dimension table that contains hierarchies, such as time, geography, or product, which can be used in multiple roles within the same data warehouse schema, allowing for flexible and efficient querying and analysis across different perspectives.
Loading...
Related Quiz
- In Hadoop MapReduce, what is the function of the Map phase?
- ________ is a distributed consensus algorithm used to ensure that a distributed system's nodes agree on a single value.
- How does data timeliness contribute to data quality?
- How do data modeling tools like ERWin or Visio support reverse engineering in the context of existing databases?
- Apache Spark leverages a distributed storage system called ________ for fault-tolerant storage of RDDs.