2 Replies Latest reply: Feb 27, 2014 9:45 AM by 1518815 RSS

    Create ETL tables for Siebel

    1518815

      The script I generated from ODI Studio for creating ETL tables in Siebel includes this DDL:

       

      CREATE TABLE SIEBEL.S_ETL_INDUS_VER (

        INDUST_SIC VARCHAR2(30 CHAR) NOT NULL,

        VERTICAL VARCHAR2(30 CHAR) NOT NULL,

        CDC$_SRC_LAST_UPDATE_DATE TIMESTAMP NOT NULL,

        CDC$_RPL_LAST_UPDATE_DATE TIMESTAMP NOT NULL,

        CDC$_DML_CODE VARCHAR2(1 CHAR) NOT NULL

      )

      ;

       

      However this table already exists in my Siebel 8.1.1.11 DB as follows:

      Name                                      Null?    Type

      ----------------------------------------- -------- -----------------

      INDUST_SIC                                NOT NULL VARCHAR2(30 CHAR)

      VERTICAL                                  NOT NULL VARCHAR2(30 CHAR)

       

      So I'll need to add the additional columns in the existing SIEBEL.S_ETL_INDUS_VER table. I'll use today's date for the Last_update_date columns as default. However, What value should I use for CDC$_DML_CODE?