Informatica Configaration

I thought this might be helpful to some one installing informatica6.2 for XP(home/professional). Install oracle before this.

Install ORACLE with defaults
SID:: name 1
SYS pwd: pwd
SYSTM pwd:: pwd 2

SQL>
Create User name 2 identified by pwd 3;
Grant Connect, resource to name 2;

Control Panel -> Create Admin User: name 3
Pwd: pwd 4

1.Install Repository Server

Domain: . (dot)
User : name 3
Pwd: pwd 4

2.Configure Repository Server
Admin Pwd: pwd 4

3.Install Client:

Repository Server Admin Console:

Host name: Your Computer Name: [DOS> hostname]
Pwd: pwd 4

Repository Manager: Create Repository
Repo Name: name 4
User: name 3

Control Panel-> Admin tools->Services: Informatica-> Properties->
General: Automatica
Logon: Check Local System Account
Check : Allow Server to Interact with Desktop

Start Informatica Service:
//This service stops automatically until u design workflow or some mappings //


4.Repository Server Admin Console:
//Any changes(Add, Delete) to be made here-> Not Repository Manger//

Console Root-> Informatica Repository Server-> Host->Repositories-> Right Click-> Add Repository


5.DB type: Oracle
Code Page: MSWIN
REPO NAME: name 4
Connect string: name 1
DB User: name 2
DB Pwd: pwd 3
Changes ¡V YES

//PMREPAGENT.exe was created//


6. Install Power center Server:

Domain: .
User : name 3
Pwd: pwd 4

Configure Informatica Server:
KEYS: Give all Keys( Platform, Oracle, ODBC)


SERVER: Server name: name 5
TCP/IP Host address: 127.0.0.1

REPOSITORY: Repository Name: name 2
Repository User : name 3
Pwd: pwd 4
REPOSITORY SERVER HOST NAME: host name




Control Panel-> Admin tools->Services: Informatica-> Properties->
General: Automatica
Logon: Check Local System Account Check : Allow Server to Interact with Desktop


Start Informatica Service:
Start-> Informatica Client
Connect Repo :
User: name 2
Pwd: pwd 3
Create Folder : name 6
Owner : name 2
Group: Administrator
Informatica -> Workflow Manager:


Connect to Repo: In the folder->Connections->Relational->
Object Definition:
Add:
Name: Oracle
Type: Oracle
User Name: name 2
Pwd: pwd 3
Connect String : name1



folder->Server->Server Browser->

Server name: name 5
Host name: host name
Server variable :

$PMROOTDir: C:\Program Files\Informatica\Informatica PowerCenter 6.2 ¡V Server
$PMSessionlog: $PMROOTDir\Sesslogs

\\Change: ¡§ / ¡§ -„³ ¡§ \ ¡§
Create ODBC DSN:
ADD DSN server name: name 7