| Sequence Generator is a passive and connected transformation. |
| Used to generate unique number of values to avoid primary key voilation in slowly changing dimension |
It contains two output ports
- NEXTVAL :: PCS generates sequence of numbers
- CURRVAL :: Generates NEXTVAL + Increamental value
|
| |
| Reusable :: |
| |
-
Sequnce generator can be made as reusable.
-
Sequence generator must be reusable , when you pass multiple load into single target .It is necessary to avoid duplicate sequence values.
-
If you use different sequence generators , it will generate duplicate values .
|
| |
| Properties :: |
| |
Start Value |
If you select Cycle, the PowerCenter Server cycles back to this value when it reaches the end value. The default value is 0. |
| End Value |
The maximum value the PowerCenter Server generates |
| Current Value |
First value of sequence |
| Cycle |
PCS cycles the sequence range after it reaches the end value. |
| Number of Cached Values |
The number of sequence values the PCS cache at a time .Use this option when multiple sessions use the same reusable sequence generator . |
| Reset |
Check this option to generate the value from current , when you run the session for next time .If not it generates from last generated value in the last session. |
| |
