Informatica7.1: Installation Steps in WINDOWS XP ( Service Pack 2) Oracle 8i

/************************************************
* INFORMATICA 7.1 Installation Steps
* OS: WINXP(SP-2)
* Oracle 8i
*************************************************/


1. Create an user for informatica metadata:-

DROP user utopia_user cascade;
CREATE USER utopia_user IDENTIFIED BY utopia_user DEFAULT TABLESPACE users QUOTA UNLIMITED ON users;
GRANT CONNECT,DBA TO utopia_user;

2. Configure IRS( Informatica Repository Sever ):-

Server port no-- 5858 ( say )
Administrator password-- 5858 ( say )
Remaining all--Keep as it is.

3. Create a New Repository Server:-

Go to ( RSAC )Repository server admin console.
Right click on Informatica Repository servers
-->New server registration.
Hostname--yours computer name.
Portnumber--IRS port number ( Here 5858 )
-->ok
Try to connect.

If its not getting connected,go to services and check whether Informatica Repository Service is running or not.If its not running,start it.

Again try to connect.

Repository server will be created as the same name as yours computer name. ( here utopia )
That utopia will have 4 things in it
>> Repositories
>>Activity Log
>>Backups
>>Available Packages

4. Create a new repository in the newly created repository server:-

-->Right click on that Repositories folder in the newly created repository server.

GENERAL TAB
------------
Repository Name--> utopia_rep
Keep remaining thing as it is.

DATABASE CONNECTION TAB
-------------------------
ConnectString-->orcl
DBUser-->utopia_user
Keep remaining thing as it is.

NETWORK TAB
-------------
Keep remaining thing as it is.

CONFIGURATION TAB
------------------
Keep remaining thing as it is.

LICENCE TAB
--------------
Update by all keys.

-->Apply

Once press the new repository will start creating.
-->ok
After finishes,double click on Repositories folder.You can see yours repository there (here utopia_rep)

5. Create a folder to work:-

Go to client-->Repository Manager ( RM ).
Double Click on your repository utopia_rep
Connect to repository dilog box will come
Username-->utopia_user
password-->utopia_user

Once connected.Go to menuber-->Folder-->Create
Create folder dialog box will come.
Name -->utopia_user_folder
Give its all permission
-->OK
Folder will be created.

6. Go to designer:-
Right Click on the repository ( utopia_rep ).-->connect
Username--> utopia_user
password-->utopia_user

-->connect
If you press on more,it will repository server info.The hostname and port number.
The folder jus created above will be shown there.
-->righ click and then open the folder.
-->Tools-->source analyzer ( to create a source )
-->go to source-->IMport from database.
-->ODBC data source ( Urs own created data source ).
-->user/password is from oracle user and password from which schema you want your source table.
-->Tools-->Warehouse Designer ( To Create a target )
-->Tools-->Mapping Designer ( To create a mapping )
Save the mapping and check whether its valid or not.

7.Go to Workflow Manager:-

-:Creating a session:-

Connect to the repository utopia_rep.
Open the utopia_user_folder.
Menu-->Tools -->Workflow Designer.
Menu-->Workflows-->Create a workflow.
GENERAL TAB
-----------
Name-->utopia_user_wrkflow1
Keep remaining things same.

PARAMETERS
-----------
Keep remaining things same.

SCHEDULER
----------
Keep remaining things same.


-: Creating a Task :-

Menu-->Tasks-->Create a task.
tasktype-->session
name-->utopia_user_task1
Once you press button,it will ask for a mapping associated with it.
Pick up that mapping we have created in mapping designer earlier.
-->ok.
-->Done

-: Linking the task and the session :-


Menu-->Tasks-->link task.
Save and check whether the workflow is valid or not.

8. Server configuration:-

Now we need to create a server in which our workflow will run.
For that
Menu-->Server-->server configuration-->new.
Server name -->utopia_user_wrkflow_server.
HOst name / IP address -->Computer name ( here utopia )
server variables-->Create a directory in your local disk ( here e:\demo )
and then $PMRoot directory -->e:\demo
Keep remaining things same.
Then -->resolve server-->ok.-->close
If the resolving done succesfully,then its fine else check...

9. Assigning the server to workflow:-
Close yours folder in Workflow Manager.Right click on the workflow server-->Assign to workflows
Check the folder and session-->assign.

10. Creating relational database connection:-
Menu-->connections-->relational-->type-->oracle-->
new-->name :relCon_utopia_user_src
user name-->scott-->password-->tiger-->connect string -->orcl

new-->name :relCon_utopia_user_tgt
user name--> utopia_user --> password --> utopia_user -->connect string -->orcl

Keep Workflow Manager open.We`ll come back here soon.



11. Setting Informatica Server Configuration:-

Go to STart-->Programs-->INformatica server setup.
Configure.

SERVER TAB
------------
server name-->utopia_user_wrkflow_server ( It should be same as workflow server name ).
TCP/IP Host address-->Keep it blank.
Keep remaining things same.

REPOSITORY TAB
---------------
repository name--> utopia_rep
Repository user --> utopia_user
Repository pasword --> utopia_user
Repository Server Host Name --> utopia ( Or your computer name )
Repository Sever Port Number --> 5858

LICENCE TAB
-----------------
Update all keys if they are not there.

COMPATIBILITY AND DATABASE
----------------------------
Keep remaining things same.

CONFIGURATION
---------------
Keep remaining things same.

JVM OPTIONS
----------------
Keep remaining things same.

HTTP PROXY
---------------
Keep remaining things same.

Apply-->ok-->exit
Go to services-->make informatica server up.

If facing problem to make it up-Check

12. Make workflow to run:-
Come back to Workflow Manager.double click on the session-->click on mapping tab.-->
click on source-->set the relational connection.
click on target -->set the relational connection-->normal load not bulk.

Save the workflow again and check if its valid or not.

13. And finally run the workflow:-
Right click on task and start workflow.

14. Check the success/failure status in Workflow monitor.