Table of Contents

Search

  1. Preface
  2. Components
  3. Business services
  4. File listeners
  5. Fixed-width file formats
  6. Hierarchical schemas
  7. Intelligent structure models
  8. Mapplets
  9. Saved queries
  10. Shared sequences
  11. User-defined functions

Components

Components

Shared sequence properties

Shared sequence properties

When you create a shared sequence, you define general properties such as the sequence name, and properties that define the sequence such as initial value, increment value, and end value.
The following table lists the properties you define for a shared sequence:
Property
Description
Name
Required. Name of the shared sequence.
Can contain alphanumeric characters and underscores (_). Maximum length is 200 characters.
Location
Project or folder in which the sequence resides.
If the
Explore
page is currently active and a project or folder is selected, the default location for the asset is the selected project or folder. Otherwise, the default location is the location of the most recently saved asset.
Description
Optional. Description for the shared sequence.
Increment By
The difference between two consecutive values in a generated sequence. For example, if Increment By is 2 and the existing value is 4, then the next value generated in the sequence will be 6.
Default is 1.
Maximum is 2,147,483,647.
End Value
Maximum value that the
mapping
task generates.
If the sequence reaches this value during the task run with rows left to process and the sequence is not configured to cycle, the run fails. If the sequence is configured to cycle, the sequence uses this value and then starts over at the Cycle Start Value.
Maximum is 9,223,372,036,854,775,807.
Initial Value
The value you want the
mapping
task to use as the initial value in the sequence the first time that the sequence is used.
If you want to cycle through a series of values, this value must be greater than or equal to the Cycle Start Value and less than the End Value.
If you reset the shared sequence, the sequence is reset to this value.
Default is 0.
Cycle
If enabled, the
mapping
task cycles through the sequence range. If disabled, the task stops the sequence at the configured End Value. The session fails if the task reaches the End Value and still has rows to process.
Default is disabled.
Cycle Start Value
Start value of the generated sequence that you want the
mapping
task to use when the sequence is configured to cycle. When the sequence reaches the end value, it cycles back to this value.
Default is 0.
Number of Reserved Values
The number of sequence values the
mapping
task caches at one time.
Must be greater than or equal to 1000.
Current Value
Displays the current start value in the sequence.


Updated August 03, 2020