Informatica 8.6.1 Hot Fix 2 – Object Check-In is Slow

If you’re using Informatica as ETL tool as we do, this may be useful if you’re working on upgrading it to the latest version 8.6.1 hot fix 2.

During the testing, our ETL developers complained that the object check-in took a long time (sometime up to 2 minutes – compared to only a few seconds in the existing environment). There are no loads or waits as far as we could see on the repository database. My gut feeling was that something was missing here. We then opened a support case with Informatica, and, sure enough, the support team asked us to try adding new indexes as follows:

CREATE INDEX OPB_VALIDAT_IDX_SR
ON OPB_VALIDATE (
OBJECT_ID, OBJECT_TYPE,
VERSION_NUMBER
);

CREATE INDEX OPB_COMPONE_IDX_SR
ON OPB_COMPONENT (
REF_OBJ_ID, OBJECT_TYPE
);

With these new indexes, the check-in is now instant!