ODI Sequences

ODI Sequences

  •  Sequences is an auto generated number based on previous value.
  • It is used to generate unique value which is used as primary key.
  • Sequences can be strings, lists, tuples or dictionaries.
  • ODI support three types of sequences
    1. Standard sequences
    2. Specific sequences
    3. Native sequences

1. Standard sequences

  • Standard sequence’s current value stored in Repository.

2. Specific sequences

  •  In this type sequence current value stored in RDBMS Table.

3. Native sequences

  •  This sequence we used from RDBMS database.
    This type of sequences is managed at RDBMS side.
Let’s see Simple Example which shows how to create sequences and how to use it


step 1: Right click on sequences and select new Sequences
b1

step 2: Give a sequence name
Define increment value
Select types of sequences that you want based on your requirement.
b1

step 3: Define context filter as a Global so You can use anywhere
b1

step 4: Create new Data store for target
we will use our database table as source datastore
b1

step 5: Give data store name
b1

step 6: Add Attribute that you want to map with source
b1

step 7: Create new mapping
b1

step 8: Give mapping name
b1

step 9: Source: Employees
Target: Sequence_datastore
b1

step 10: Drag source and target into mapping area
Map source and target Attribute(manually or automatically by name)
b1

step 11: Select Attribute in which you want to apply sequences
b1

step 12: Select sequences from ODI object
b1

step 13: Define Integration type based on requirement
b1

step 14: Go to physical architecture
Click on target and select IKM
b1

step 15: Run mapping
b1

step 16: See status on Operator
b1

step 17: Right click on target to view data
b1

step 18: Here you can see Target table
b1

How to create and Use Native Sequences
> This sequence we used from RDBMS database.
This type of sequences is managed at RDBMS side.

native-sequnces

Leave a Reply

Your email address will not be published. Required fields are marked *