0 Replies Latest reply: Jun 23, 2010 8:19 AM by 780997 RSS

    SILOS.SIL_ActivityFact_Full corrupting the integration_ID in W_ACTIVITY_F

    780997
      Hello Experts,

      I am working with a OBIEE system pulling data from a Siebel system and I have a problem with an informatica ETL workflow which is corrupting the Integration_ID in the warehouse table W_ACTIVITY_F when it is moved from the staging table W_ACTIVITY_FS. In some cases up to three characters are being stripped off when the data is copied to the warehouse table, but it varies.

      The workflow in question is SIL_ActivityFact_Full which uses the mapping SIL_ActivityFact. This issues causes a unique constraint to fail (see error below). An example of the problem can be seen below.

      Does any body have any thoughts?

      I am working with informatica 8.1.1 and OBI apps 7.9.5.1

      The Subject area is SIEBEL CRM Public sector.

      warehouse Staging

      1-17O4     1-17O42
      1-17O4     1-17O46
      1-17O4     1-17O4C
      1-17O4     1-17O4I


      NOMALY INFO::: Error while executing : CREATE INDEX:W_ACTIVITY_F:W_ACTIVITY_F_U1
      MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
           W_ACTIVITY_F_U1
      ON
           W_ACTIVITY_F
      (
           DATASOURCE_NUM_ID Asc
           ,INTEGRATION_ID Asc
      )
      NOLOGGING PARALLEL


      Thanks

      Dave