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

      BG_Sequence

      Description

      The Default Term named BG_Sequence contains the Business Key value of a row in a Multi-Active Satellite.

      Format

      The BG_RowHash is an int.

      Value

      The value in the Default Term BG_Sequence should be distinct for each row and can be the value of:

      • A Source Term if it fulfills the requirement (is different for each row)
      • A calculation with a ROW NUMBER function if no Source term can be used. Example:
      ROW_NUMBER() OVER(PARTITION BY BusinessEntityID ORDER BY PhoneNumber)