2 Replies Latest reply: Jul 5, 2012 10:04 AM by 932942 RSS

    ODI SCD2 Error

    932942
      Hi I am trying to implement SCD2 in ODI. I am getting the error at the step updating the existing rows. It is taking space before the comma in the update statement below. can you please let me know what would be the issue

      error
      ODI-1228: Task INF_<NAME>(Integration) fails on the target ORACLE connection <CONN_NAME>Caused By: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification


      Statement


      update     ODW_DDS.<TABLE_NAME> T
      set     (
           
           ,T.CREATED_BY,
           T.CREATED_DATE,
           T.MODIFIED_BY,
           T.MODIFIED_DATE
           ) =      (
                select     
                     ,'ODI',
                     SYSDATE,
                     'ODI',
                     SYSDATE
                from     ODW_DDS.I$_SHIPMENT_FACT X
                where     X.SHIPMENT_ID     = T.SHIPMENT_ID
                and     X.IND_UPDATE     = 'U'
                )
      where     (T.SHIPMENT_ID)
           in     (
                select     S.SHIPMENT_ID
                from     ODW_DDS.I$_SHIPMENT_FACT S
                where     S.IND_UPDATE     = 'U'
                )
      and     T.CURR_IND     = 1
      and     END_TIMESTAMP     = to_date ('01-01-2400', 'mm-dd-yyyy')