Properties
      Back to home
      1. biGENIUS-X Knowledge Base
      2. Generators
      3. 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:

      Example:

      Default Value

      The default value is Truncate Insert.