Creating sequence using odi in target table baesd on database sequence

Oracle Data Integrator supports two types of sequences:
• Standard sequences, whose last value is stored in the Repository,
• Specific sequences, whose last value is stored in an RDBMS table cell. Oracle Data Integrator undertakes to read the value, to lock the row (for concurrent updates) and to update the row after the last increment.

My database sequence

create sequence odi_seq

minvalue 1

maxvalue 1000

start with 1

increment by 1

Open designer select the model tab and import the source tables

Map both the source tables

Next, click on icon
Target Datastore window will appear pull your target table

Click on Source_id mapping section in below you will get mapping of source_id window

Use the below syntax in implementation section

<%=snpRef.getObjectName( "L","ODI_SEQ", "D" )%>https://docs.google.com/document/edit?id=1GE0yQddKlRl6JJ7sdAnYPFqyh38ko585011IDIcZu5g

Where odi_seq is your sequence name

Import IKM and assign that to your FLOW

Then execute your interface, in database for the source_id column it will assign unique numbers