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

Relationships from Link (Business Rule)

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 Same As Link or Hierarchical Link has exactly two relationships, both to the same Hub. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-20000.

Message

The client shows an error with this text on the model object. <model object name> and <type> stand for its name and type.

Model object '<model object name>' of type '<type>' has the wrong amount
of relations defined. The amount of relations to the same Hub or
Business Hub should be exactly 2.

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

Error popup of a Same As Link card with Error ID-20000 and the message details

Cause

The Same As Link, Hierarchical Link, Same As Business Link or Hierarchical Business Link has more or fewer than two relationships, its two relationships point to different model objects, or they point to a model object that is not a Hub or Business Hub.

Fix

  1. Open Manage Relationships of the link.
  2. Point both relationships to the same Hub or Business Hub, see Edit a Relationship, and delete any further relationship. The error disappears.

Check the result

The error icon is gone from the link, and generation is no longer blocked by it.

Example

In a Data Vault project on Microsoft SQL Server, the second relationship of the Same As Link load_sal points to the Hub common_employee instead of load_customer_hub. The client shows:

Model object 'load_sal' of type 'Same As Link' has the wrong amount of
relations defined. The amount of relations to the same Hub or Business
Hub should be exactly 2.

Related articles