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

Fact Load Strategy selected (Business Rule)

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

This business rule checks that every dataflow of a Fact or Mart Fact has a Fact Load Strategy selected. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-10026.

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 has no option
for property FactLoadStrategy selected. At least one value has to be
selected.

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

Error popup of a Mart Fact card with Error ID-10026 and the message details

Cause

A dataflow of the Fact or Mart Fact has no value selected in Fact Load Strategy.

Fix

  1. Open Edit Dataflow for the dataflow, see Edit a Dataflow.
  2. Select Truncate Insert or Insert in Fact Load Strategy and save. 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 Fact Load Strategy of the Mart Fact deduplication_partition_mart_fact is cleared. The client shows:

Model object 'deduplication_partition_mart_fact' of type 'Mart Fact' has
has no option for property FactLoadStrategy selected. At least one value
has to be selected.

Related articles