- biGENIUS-X Knowledge Base
- Generators
- Properties
Fact Load Strategy (Dataflow)
Description
The Fact Load Strategy Property is available when you edit a Dataflow.
It defines how a Fact Model Object will be loaded.
Format
The Fact Load Strategy is a List of values.
The possible values are:
- Truncate Insert:
- All the existing data in the persistent table are truncated, and then the new data are loaded
- It is usually used for an initial load
- Insert:
- All the new data are inserted
If you use a Fact Load Strategy set to Insert, you may have duplicated entries if the incremental load is not managed in the Stage Layer.
See: BG_Incremental Filter.
To have a historization of data, please:
- Set the Fact Load Strategy Insert
- Configure incremental load in the Stage Model Objects used as source
Example:
Default Value
The default value is Truncate Insert.