Restoring repository (.rep) in Informatica 9.0

Restoring repository (.rep) in Informatica 9.0

STEP1:- Copy infa repository Oracle_BI_DW_Base.rep  from below path in D:\Middleware_Home\Oracle_BI1\biapps\dwrep\Informatica\Repository

STEP2:- Copy rep into D:\Informatica\9.0.1\server\infa_shared\Backup”

First of all, In Informatica installation directory, keep the restorable repository file (With extension .rep) in the backup location e.g.  “D:\Informatica\9.0.1\server\infa_shared\Backup”

Now, In Informatica administrator webpage, select the repository service then on right side in repository properties, click edit and change the operating mode to Exclusive.

Now, on the right hand top select the “Action” dropdown menu and select repository contents, and navigate to ‘Delete’. Delete the contents in repository.

After deleting again on the same dropdown menu under repository content select ‘Restore’.

Note: - Till the time previous data is not deleted the ‘Restore’ link will stay grayed out.