- Install a database ( I use oracle, you can try other databases also!!!).
- Creating a windows user with Administrator privileges.
- Installing PowerCenter Server.
- Create PowerCenter Repository service and Integration service.
- Installation of PowerCenter Client.
Database Installation:
Install Microsoft loopback adapter with static IP.Database installation is pretty much straight forward. I used oracle 10g and it should work with many other databases.
Create a database user with DBA privileges. Lets create a user name admin with password admin.
Create a database user with DBA privileges. Lets create a user name admin with password admin.
SQL> Grant dba to admin identified by admin
Windows Setup:You need to install informatica with Administrator user or user that has Administrator privileges. I had issue while creating the repository service if the user does not have enough privileges. Lets create a windows user admin with password admin.
PowerCenter Server Installation:
login to windows with admin user and start the installation by double clicking install.bat.
 |  |
Select English & OK | Next |
 |  |
Select Install PowerCenter 8.6.0 | Browse the license Key |
 |  |
| Next | Next |
 |  |
| Choose install directory | Keep default settings |
 |  |
| Next | select create new domain option |
 |  |
| provide database details. We created admin user for this | admin is the domain username and password |
 |  |
| uncheck Run Informatica option | Installation completed |
Creating repository and Integration service:Installation of the server is completed and now we need to configure it. Go to
Start>All Programs>PowerCenter 8.6.0> Services> PowerCenter Administration Console
 |  |
Loin with admin/admin | Select Administrator console |
 |  |
click on create and select repository service | Enter the details as specified |
 |  |
Click on create and select integration service | select enable |
Click on repository repoinfo and select properties tab.
In General properties, edit and modify the Exclusive mode to Normal. This will restart the repository.
If the Integration service failed to start at the creation step, disable and enable it. It should start properly now.
Client Installation:Double click on Install batch file to install client
 |  |
Select English & OK | Next |
 |  |
Select Install option | Next |
 |  |
Next | Done |
