|
|
|
INSTALALTION |
| |
|
Install
- Keep the INFORMATICA CD into the CD Rom
- Click on CD-Drive
-
| Click on the icon |
 |
- Now it is showing prompt box with option
- Now click on " Power Center for windows" button.
- while in the process it asks you to configure Repository Server and Informatica Server .That you can do it now or later on.We will tell how to cofigure it in the next few lines.
- Successfully installed.
|
Configure Repository Server
- Go to Program files
- Informatica power center 7.1.1 > Repository Server > Repository Setup.
- You see the prompt screen of Repository server with differnt options.
- Set the "Server Port Number" any value between 5002 to 65535.
- Set the "administrative password" of your own choice.It is case sensitive.
- Now we successfully configured Repository Server.
|
Add Data Source
- Click on Control panel
- Click on Administrator tool >Data source (ODBC)
- Now click on add button.It shows set of drivers of differnt data sources.Select the right data source.For eg., If your database is Oracle then select respected oracle driver.
- Cick on OK
- It ask for description of the Data Source.You can name it as you want for eg., ora_data_src.
- Click on OK
- Here you added the data source successfully.
|
Start Services
- Clcik on Control Panel
- Now click on Administrator Tool> Services
- You see the prompt display on the screen.
- Right click on "Informatica Repository Server" and click on start.
- Right click on "Informatica" and click on start.
- successfully started the services.
|
Create two users
- Login to your database .
- Create two users one for Repository and other for Target Database.
- This are necessary to secure the data in the repositories.
- For eg., Repository (Username :: Rep_one , Password :: r) and Target (username::trg_wh , Password :: t).
- After creating the users.Test it by connecting to the database.
|
|
|
|