Properties
      Back to home
      1. biGENIUS-X Help Center
      2. Generators
      3. Properties

      Deduplication Partition (Dataflow)

      Description

      The Property named Deduplication Partition is available when you edit a Dataflow. 

      It allows you to specify which Term to use for the ORDER BY of the Partition deduplication of a Dataflow for a Model Object.

      It cannot work without the Deduplication Method Property set to Partition:

      Format

      The Deduplication Partition is a String.

      Please fill in the name of a Term of the Model Object.


      Example:

      Default Value


      The default value for all Model Objects is empty.

       

      Impact

      The value of the Deduplication Partition is used during a load of a Model Object to duplicate the source rows before applying the business rules and the modeled transformations. In the case of the Deduplication Method set to Partition, the value of the Deduplication Partition will be used to set the ORDER BY of the ROW NUMBER().

      If no value is set, the default ORDER BY will be applied.