QSM-03218
More than one table is classified as a fact table.
Cause
More than one of the base tables of the materialized view was classified as a fact table for the purposes of synchronous refresh, which requires exactly one fact table. Synchronous refresh requires that the defining query of a materialized view conform to either the star or snowflake schema. A table can be either a fact or dimension table. However, only one (and exactly one) can be fact table and the rest must be dimension tables.
Action
Check the joins of the query to ensure they conform to the requirements.
QSM-03218
More than one table is classified as a fact table.
Cause
More than one of the base tables of the materialized view was classified as a fact table for the purposes of synchronous refresh, which requires exactly one fact table. Synchronous refresh requires that the defining query of a materialized view conform to either the star or snowflake schema. A table can be either a fact or dimension table. However, only one (and exactly one) can be fact table and the rest must be dimension tables.
Action
Check the joins of the query to ensure they conform to the requirements.
QSM-03218
More than one table is classified as a fact table.
Cause
More than one of the base tables of the materialized view was classified as a fact table for the purposes of synchronous refresh, which requires exactly one fact table. Synchronous refresh requires that the defining query of a materialized view conform to either the star or snowflake schema. A table can be either a fact or dimension table. However, only one (and exactly one) can be fact table and the rest must be dimension tables.
Action
Check the joins of the query to ensure they conform to the requirements.
