Multiple choice technology databases

The dimension tables in a star schema data mart that adhere to a common structure, and therefore allow queries to be executed across star schemas is called _______. (Note: For example, the Calendar dimension)

  1. Degenerated dimension

  2. Slowly changing dimensions

  3. Conformed dimensions

  4. Junk dimension
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Conformed dimensions are dimension tables that share the same structure and meaning across multiple star schemas or data marts. This allows queries to be executed across different schemas seamlessly. A Calendar dimension is a classic example - it can be used consistently across sales, inventory, and financial data marts.

Keep practicing — related questions