Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Sequence Generator values

Sequence Generator values

When you run a
mapping
task that includes a Sequence Generator transformation in the mapping, you can change the beginning value for the sequence.
To change the beginning value, you change the
Current Value
field in the
Sequences
or
Persistent Values
page in the
mapping
task wizard. The
Current Value
field shows the first value the task will generate in the sequence, based on the last value generated in the last task execution.
For example, the last time you ran the CustDataIDs task, the last value generated was 124. The next time the task runs, the first number in the sequence is 125 because the Sequence Generator transformation is configured to increment by 1. If you want the sequence to begin with 200, you change the
Current Value
to 200.
The Sequences page in the mapping task wizard displays the name of the Sequence Generator transformation, the current value, and the initial value. In this example, the current value is 125.

0 COMMENTS

We’d like to hear from you!