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