Use to define sequences.
A sequence is a variable that increments itself each time it is used. Between two uses, the value can be stored in the repository or managed within an external RDBMS table.
Oracle Data Integrator supports three types of sequences:
Standard sequences: The last value is stored in the repository.
Specific sequences: The last value is stored in an RDBMS table cell. Oracle Data Integrator undertakes to read the value, to lock the row (for concurrent updates), and to update the row after the last increment.
Native sequences: This type of sequence maps to a sequence defined in and managed by a database engine.
The Sequence Editor has the following tabs:
| Properties | Description |
|---|---|
| Name | Name of the sequence, in the form it is used. This name should not contain characters that could be interpreted as word separators (blanks, and so forth) by the technologies the sequence is used on. Upper and lower case are not distinguished during interpretation.
For example: |
| Increment | Value of the increment. This value can be positive or negative. This increment only applies to standard and specific sequences. |
| Scope | Validity range of the sequence, either Global or Project. A sequence can be valid for all projects (a global sequence), or only for the current project. Oracle Data Integrator examines Project-level sequences first, before evaluating Global-level sequences. Thus, if a sequence ORDER_NO exists at both project-level and global-level, only the project-level sequence value can be evaluated. |
| Standard Sequence | Select this option for storing the sequence value in the Oracle Data Integrator repository. |
| Position | Last value allocated for a standard sequence. |
| Specific Sequence | Select this option for storing the sequence value in a table in a given data schema. |
| Schema | Logical schema containing the sequences table. |
| Table | Table containing the sequence value. |
| Attribute | Name of the attribute containing the sequence value. |
| Filter to retrieve a single row | When the sequence table contains more than one row, a filter should be completed in order to locate this row in the table. This filter picks up the SQL syntax of the data server.
For example: |
| Native Sequence | Select this option if your sequence is implemented in the database engine. Position and increment are fully handled by the database engine. |
| Schema | Logical schema containing the sequence object. |
| Native sequence name | Name of the database sequence object. |
| Properties | Description |
|---|---|
| Context Filter | Select a context for displaying the values for a sequence on this context. |
| Context | Name of the context. |
| Value | Value of the sequence in the given context. |
"Creating Sequences" in the "Creating and Using Procedures, Variables, Sequences, and User Functions" chapter in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator