Skip to content
  • There are no suggestions because the search field is empty.

Identity Terms amount (Business Rule)

Applies to
Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle

This business rule checks the number of identity terms of a model object. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-10016.

Message

The client shows an error with this text on the model object. <model object name> and <type> stand for its name and type, <amount> for the required number, for example exactly 1.

Model object '<model object name>' of type '<type>' has the wrong amount
of identity terms defined. The amount of identity terms should be
<amount>.

On the model object card, point to the error icon to see this message with the rule ID: Error ID-10016. The Generate Artifacts page lists the message without the ID.

Error popup of a PIT card with Error ID-10016 and the message details

Cause

The model object has fewer or more terms marked as identity than its type requires:

  • Exactly 1: Stage, Store Entity, Mart Dimension, Mart Fact, Reference Table and Hierarchy Flatten.
  • Exactly 2: Entity, Fact, PIT, the Hub and Link types and the Record Tracking satellites of Data Vault, including their Business Vault variants.
  • Exactly 3: the other satellite types of Data Vault, including their Business Vault variants.

Fix

  1. Open Manage Terms of the model object.
  2. Mark terms as identity, or clear the identity mark of extra terms, until the number fits. The identity terms are usually Default Terms, for example <model object name>_SK on a Mart Dimension. 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 Mart project on Microsoft SQL Server, the identity mark of the term mvl_bk_only_SK of the Mart Dimension mvl_bk_only is cleared. The client shows:

Model object 'mvl_bk_only' of type 'Mart Dimension' has the wrong amount
of identity terms defined. The amount of identity terms should be
exactly 1.

Related articles