Applies to
Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle
Architecture: Data Vault
This business rule checks that a Multi-Active Satellite or an Effectivity satellite maps its required Default Term. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-10007.
Message
The client shows an error with this text on the model object. <model object name> and <type> stand for its name and type, <term name> for the unmapped term.
Model object '<model object name>' of type '<type>' has unmapped term '<term name>' defined. This term has to be mapped.
On the model object card, point to the error icon to see this message with the rule ID: Error ID-10007. The Generate Artifacts page lists the message without the ID.
Cause
In at least one dataflow, the term mapping of a required Default Term has neither an expression nor a default value:
- Multi-Active Satellite:
BG_Sequence. - Effectivity Satellite, Effectivity Link Satellite, Effectivity Business Satellite and Effectivity Business Link Satellite:
BG_Effectivity_Begin.
Fix
- Open Manage Term Mappings of the model object.
- Open Edit Term Mapping for the term in the details, enter an expression or a default value and save, see Edit a Term Mapping. Repeat for every dataflow set. The error disappears.
Check the result
The error icon is gone from the model object, and generation is no longer blocked by it.
Example
In a Data Vault project on Microsoft SQL Server, the term mapping of BG_Effectivity_Begin of the Effectivity Satellite load_loyaltycard_esat is cleared. The client shows:
Model object 'load_loyaltycard_esat' of type 'Effectivity Satellite' has unmapped term 'BG_Effectivity_Begin' defined. This term has to be mapped.