Search code examples
business-intelligenceoracle-data-integrator

ODI 12C - Business Key auto increment

Using ODI 12C, I Have a dimension with a combination of 2 Primary Keys. I Just want to perform a business key with auto-increment .

NOTE : - I Don't need a SCD behavior

Solution

  • I did this :

    1 - Create sequence in Database Schema ( with no cache )

    2 - Call it in the the needed mapping :

        <%=odiRef.getObjectName("L", "SEQ_NAME", "D")%>.nextval

    3 - Set the mapping to be :

    Active for inserts only, uncheck NOT NULL condition, EXCUTE ON HINT :TARGET

    4 - PUT CKM TO : CKM SQL

    5 - Run