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.

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
- Open Manage Relationships of the link.
- 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
- See also: Same As Link, Hierarchical Link, Edit a Relationship, Relationships amount (Business Rule), Understand warnings and errors