Skip to content
Contact us Go to Customer Portal
  • There are no suggestions because the search field is empty.

Dataflow Set Model Objects amount (Business Rule)

Applies to
Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle
Architecture: Stage · Data Vault

This business rule checks the number of source model objects (Dataflow Set Model Objects) in each dataflow set. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-10003.

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 allowed number, for example exactly 1.

Model object '<model object name>' of type '<type>' has the wrong amount
of source model objects defined. The amount of source model objects per
dataflow set should be <amount>.

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

For Current and History Views, the details also name the counted types, for example "of type Hub, Link, Hierarchical Link, Driving Key Link".

Cause

The allowed number per dataflow set depends on the type:

  • Stage, PIT and Business PIT: at least one. Exactly one on the Microsoft SQL Server Stage Files and Stage OpenQuery configurations.
  • Current View, History View and their Business Vault variants: at least one, of which exactly one is a Hub or a Link of any kind.

Fix

In Manage Term Mappings, add or remove source model objects in the dataflow set until the number fits, see Add a Model Object to a Dataflow Set and Remove a Model Object from a Dataflow Set.

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 Current View based_on_hub_single_satellite_without_pit_rcv gets the Hub common_customer as a second Hub source. The client shows:

Model object 'based_on_hub_single_satellite_without_pit_rcv' of type
'Current View' has the wrong amount of source model objects defined. The
amount of source model objects of type Hub, Link, Hierarchical Link,
Driving Key Link per dataflow set should be exactly 1.

Related articles