Hi ,

For using Native Sequence generation in ODI interface, you can follow the below steps.


CREATE TARGET TABLE

CREATE TABLE "TARGET"."SEQUENCE_TRIAL"
   ( "FAMILY_ID" NUMBER,
"EMP_NAME" VARCHAR2(255 CHAR)
   )





CREATE SEQ_FAMILY in the TARGET schema

CREATE SEQUENCE SEQ_FAMILY INCREMENT BY 1 MAXVALUE 99999999999999999 MINVALUE 1 CACHE 20;






Once the target table is imported to the model, create the interface and map the EMP_NAME to the NAME column from the source as shown below



Create the Sequence:

From the designer tab , projects, click on sequences and create a new sequence SEQ_FAMILY_ID as shown below

Select Native Sequence and select the TARGET schema and use the search utility as shown below to browse our SEQ_FAMILY that was created in the first step



Open the interface and navigate to the MAPPING tab and use the property selector to select the FAMILY_ID column from the target table as shown below.

User the Expression builder to add the SEQUENCE as shown below, click apply and OK.




Make sure you have specified the KEY as shown below in the new sequence column.



Select the IKM as shown below and enable FLOW CONTROL = TRUE



Verify the target table and execute the interface.



The target table is now populated with the NATIVE SEQUENCE as shown below.



Thanks

Sandeep