Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

QSM-03214

The partition key of the MV is derived from table string whereas the partition key of the fact table is related by a join to dimension table string.

Cause

The analysis by synchronous refresh indicated that the partition key of the materialized view (MV) was related to a column of a dimension table that was not the dimension table to which the partition key of the fact table was joined.


Action

Check the partition keys of both the fact table and materialized view and check the joins of the materialized view to ensure the functional dependency check passes.