Oracle^® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Setting Up the Informatica Server and Informatica Repository Server >

Process Of Setting Up The Informatica Server

To set up the Informatica Server in Informatica PowerCenter

1. Navigate to Programs > Informatica PowerCenter 7.1.4 > Informatica PowerCenter 7.1.4 OEM for Oracle - Server > Informatica Server Setup.
2. In the Informatica Server Setup Application - Options window, select Configure Informatica Service, and then click Continue.
   
3. In the Server tab, enter the following:

   Field	Description
   Server Name	A logical name for the Informatica Server. It is recommended that you enter ORACLE_BI_DW_SERVER.
   TCP/IP Host Address	The IP address or name of the machine on which you plan to run the Informatica Server.
   Max no. of concurrent sessions	From 1 to 15 sessions (default is 10).
   Shared Memory	The default is 2,000,000. You should specify 200,000 for each session specified in the 'Max no. of concurrent sessions' field. For example, if you specify 5 in the 'Max no. of concurrent sessions' field, you should specify 1,000,000 in the Shared Memory field.

4. In the Repository tab, enter the following:

   Field	Description
   Repository Name	A logical name for the Informatica repository. It is recommended that you enter Oracle_BI_DW_Base. For Teradata databases, it is recommended that you enter Oracle_BI_DW_Teradata.
   Repository User	The account used to access the repository. It is recommended that you use Administrator as the username.
   Repository Password	The password you use to connect to the Repository Server from the Repository Manager. It is recommended that you use Administrator as the password.
   Repository Server Host Name	The host machine name where the Informatica Repository Server is installed.
   Repository Port Number	The port number the Repository Server uses to connect to repository client applications. By default, this value is 5001. It is recommended that you use the default value.

5. In the Licenses tab:
   1. Leave the default License File Name as pm.lic.
   2. If you have an option or connectivity license key, enter it in the "with Key" field, and click Update. Do this for each option and connectivity license key.
6. In the Compatibility and Database tab:
   1. Make sure the "Treat CHAR as CHAR on read" option is selected.
   2. Make sure the maximum number of database connections is 100.
7. In the Configuration tab, set the Data Movement Mode.

   NOTE:  You must run the Informatica Server in Unicode mode if your source data contains multibyte or ISO 8859-1 (8-bit ASCII) data.

   1. Select the ASCII or UNICODE option.
   2. If you select the UNICODE option, remove the check from the Validate Data Codepages check box, and check the Output Session Log in UTF8 check box.
      
   3. Leave the default values in the remaining fields.
8. In the JVM Options tab, leave the default values in all fields.
9. Click OK in the Configure Informatica Service dialog box to complete the configuration of the Informatica Server service.

If you are using a Teradata database, you cannot start the Informatica Server until you have completed the procedures in the section Setting the Code Page File Property for Unicode Environments on Teradata Databases.