[ODI 10g] Sequence

Sequence in ODI10g

Database Sequence

Create a database Sequence in Oracle.

create sequence test_sequence
minvalue 2
maxvalue 999
start with 2
increment by 2 

Map your interface

Call the sequence in the respective column using this format

<SCHEMA_NAME>.<SEQUENCE_NAME>.NEXTVAL

TEMP.TEST_SEQUENCE.NEXTVAL

TEMP                    -  SCHEMA_NAME

TEST_SEQUENCE   -   SEQUENCE_NAME

• Map it to  ‘Target’
• Use ‘Insert’ only Option

run your interface and check for data.

ODI Sequence

Create an ODI sequence with the required option

Map the column and the sequence with the ODI_SEQUENCE as

:ODI_SEQ_NEXTVAL

:<COLON>_<ODI_SEQUENCE>_NEXTVAL

• Map it to  ‘Target’
• Use ‘Insert’ only Option
• IKM SQL TO SQL APPEND  ( for Row by Row processing)

run the interface and check for the data