2 Replies Latest reply on Jul 5, 2012 3:04 PM by 932942

    ODI SCD2 Error

      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

      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


      update     ODW_DDS.<TABLE_NAME> T
      set     (
           ) =      (
                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')