Supported Fact Load Strategies (Business Rule)

This business rule checks that the dataflows of a Fact or Mart Fact use only the Fact Load Strategy values Insert and Truncate Insert. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-10025.

Message

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

Model object '<model object name>' of type '<type>' has unsupported load
strategy '<value>' defined. Supported load strategies are: Insert,
Truncate Insert.

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

Cause

Fact Load Strategy of a dataflow of the Fact or Mart Fact has a value other than Insert and Truncate Insert, a value the client does not offer.

Fix

1. Open the dataflow of the model object, see Edit a Dataflow.
2. Set Fact Load Strategy to Insert or Truncate Insert 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 dataflow of the Mart Fact deduplication_distinct_mart_fact has Fact Load Strategy Upsert, a value the client does not offer. The client shows:

Model object 'deduplication_distinct_mart_fact' of type 'Mart Fact' has
unsupported load strategy 'Upsert' defined. Supported load strategies
are: Insert, Truncate Insert.

Related articles

• Reference: Fact Load Strategy (Dataflow)
• See also: Edit a Dataflow, Fact Load Strategy selected (Business Rule), One Fact Load Strategy selected (Business Rule), Understand warnings and errors