Database Reference
In-Depth Information
•
Increment By
: This is the value by which you wish to increment the consecutive
numbers from the
NEXTVAL
port.
The default value is 1 and the maximum value is 2147483647.
•
End Value
: This is the maximum value that the Integration Service can generate.
If the Sequence Generator reaches the end value and is not configured for the
cycle, the session will fail, giving the data overflow error. The maximum value is
9223372036854775807
.
•
Current Value
: This indicates the value assigned to the
CURRVAL
port. Specify
the current value that you wish to have as the value for the first record. As men-
tioned earlier, the
CURRVAL
port gets assigned to
NEXTVAL
, and the
CURRVAL
port is incremented.
The
CURRVAL
port stores the value after the session is over, and when you run
the session the next time, it starts incrementing the value from the stored value if
you have not checked the reset option. If you check the reset option, Integration
Services resets the value to
1
. Suppose you have not checked the
Reset
option
and you have passed 17 records at the end of the session; then, the current value
will be set to
18
, which will be stored internally. When you run the session the
next time, it starts generating the value from
18
.
The maximum value is
9223372036854775807
.
•
Cycle
: If you check this option, Integration Service cycles through the sequence
defined. If you do not check this option, the process stops at the defined
End
Value
.
If your source records are more than the end value defined, the session will fail
with an overflow error.
•
Number of Cached Values
: This option indicates how many sequential values
Integration Services can cache at a time. This option is useful only when you are
using reusable Sequence Generator transformations.
The default value for nonreusable transformations is
0
. The default value for re-
usable transformations is
1000
. The maximum value is
9223372036854775807
.
•
Reset
: If you do not check this option, Integration Service stores the value of the
previous run and generates the value from the previously stored value. Otherwise,
the integration will get reset to the defined current value and will generate values