ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Sequence

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

image

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

image

run your interface and check for data.

image

ODI Sequence

Create an ODI sequence with the required option

image

Map the column and the sequence with the ODI_SEQUENCE as

:ODI_SEQ_NEXTVAL

:<COLON>_<ODI_SEQUENCE>_NEXTVAL

image

  • 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

image

15 Comments

Leave a Reply

Required fields are marked *.


This site uses Akismet to reduce spam. Learn how your comment data is processed.