Multiple choice technology enterprise content management

In a scenario having multiple facts (FACT A & FACT B)and conformed dimensions (CONF D), what is the best way to fire queries involving both?

  1. Having a single SQL query with FACT A, FACT B and Conf D.

  2. Have a individual query between FACT A & Conf D, and a individual query between FACT B & Conf D.

  3. Have three individual queries, one for each table.

  4. A and B

  5. All of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

With conformed dimensions, the best practice is to query each fact table separately against the shared dimension (individual queries). A single query joining both facts directly would create a snowflake pattern that can cause performance issues and incorrect results due to fact table explosion (cartesian product of fact rows).

Keep practicing — related questions