Fact Load Strategy Dataflows amount (Business Rule)

This business rule warns when a Fact or Mart Fact with more than one dataflow uses Fact Load Strategy Truncate Insert. It raises a warning, and generation continues. The rule ID is ID-10048.

Message

The client shows a warning 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 fact load
strategy 'Truncate Insert' and more then one dataflow defined. This
could cause loss of data.

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

Cause

The Fact or Mart Fact has more than one dataflow, and at least one dataflow has Fact Load Strategy Truncate Insert.

Fix

Do one of the following:

• Set Fact Load Strategy Insert on every dataflow, see Edit a Dataflow. With Insert, configure an incremental load as well, see Fact Load Strategy Insert needs Incremental selected (Business Rule).
• Keep one dataflow and delete the others, see Delete a Dataflow.

Check the result

The warning icon is gone from the model object.

Example

In a Data Mart project on Microsoft SQL Server, both dataflows of the Mart Fact multiple_dataflows_mart_fact get Fact Load Strategy Truncate Insert. The client shows:

Model object 'multiple_dataflows_mart_fact' of type 'Mart Fact' has fact
load strategy 'Truncate Insert' and more then one dataflow defined. This
could cause loss of data.

Related articles

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