Informatica 8.1 step by step Installation

Informatica PowerCenter 8.1.1 is used for this installation on Windows XP.

For the software download link, please post your comment and details.

Informatica PowerCenter supports following Databases

Pre-requisites:

Database (I am using Oracle 9i for this installation).

Download Oracle 9i from the link below

http://www.oracle.com/technology/software/products/oracle9i/index.html

Other Oracle versions can be downloaded from the link below

http://www.oracle.com/technology/software/products/database/index.html

Create a Table Space in Oracle database.To create the Oracle User you need to have access to System or Sys user to create. To create the Table Space go to the SQL Prompt and paste the code. Path for the datafile should be given. It is not mandatory to create the Table Space however its a good practice to create one. See the code below.

CREATE TABLESPACE INFORMT_TABSPACE

LOGGING

DATAFILE 'C:\ORACLE\ORADATA\INFORMT\INFORMT_TABSPACE.DBF'

SIZE 32M

AUTOEXTEND ON

NEXT 32M MAXSIZE 2048M

EXTENT MANAGEMENT LOCAL;

Create a separate Oracle User to install the Informatica Repository. To create the Oracle User you need to have access to System or Sys user to create. Go to the SQL Prompt and paste the code. It is not mandatory to create the Oracle User however you need to specify one Oracle User name while installing the Informatica Server, and its a good practice to create a separate Oracle User just for the Informatica Repository. See the code below how to create a user in Oracle Database.

CREATE USER DWH IDENTIFIED BY DWH

DEFAULT TABLESPACE INFORMT_TABSPACE

TEMPORARY TABLESPACE TEMP

QUOTA 1024M ON INFORMT_TABSPACE

QUOTA UNLIMITED ON TEMP;

The above code creats a user with the Name DWH and Password DWH in the table space INFORMT_TABSPACE.

Temporary table space is TEMP and the space quota alloted is 1024 MB on the INFORMT_TABSPACE table space and unlimited quota on TEMP.

GRANT CONNECT TO DWH;

GRANT RESOURCE TO DWH;

The above code give the CONNECT and RESOURCE privileges to the user DWH.

Next: Informatica 8.1.1 Step by Step Server Installation

Click Here To Post Your Comments