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 22.214.171.124
The Subject area is SIEBEL CRM Public sector.
NOMALY INFO::: Error while executing : CREATE INDEX:W_ACTIVITY_F:W_ACTIVITY_F_U1
MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX