Oracle^® Business Intelligence Applications Upgrade Guide > Upgrading Oracle BI Applications >

Upgrading the Informatica Repository

Follow this procedure to upgrade the Informatica repository.

To upgrade the Informatica repository

1. Make sure you have backed up and renamed your current Informatica repository.

   For instructions, see the Informatica documentation, which is provided in the Third_Party_Software\Informatica\Informatica 7.1.4 PowerCenter Doc folder of the Oracle Business Intelligence Applications CD-ROM.

2. Copy the Oracle_BI_DW_Base.rep file from the folder OracleBI\dwrep\Informatica\Repository into the folder Informatica PowerCenter 7.1.4\RepositoryServer\bin\Backup.
3. Launch the Informatica Repository Console and restore Oracle_BI_DW_Base.rep (located in Informatica PowerCenter 7.1.4\RepositoryServer\bin\Backup).
4. Copy the custom folder from your previous Informatica repository to the newly created Informatica repository:
   1. Launch the Informatica Repository Manager, and connect to both your previous and newly created Informatica repositories.
   2. Copy the Custom folder in your previous repository into the newly created Informatica repository.
   3. Create an individual workflow for each of the mappings in the Custom folder.
   4. New system columns were added to the Oracle Business Analytics Warehouse for Oracle BI Applications version 7.9. Review your custom mappings to determine whether the new columns need to be added to the mapping.
   5. Register the mappings in the DAC.

      You will verify your customized mappings in the procedure Verifying ETL Customizations, which you perform after the data migration.