Installing "Informatica Developer" ...

After installing Inforamtica 9.0.1 was doing only traditional work using Power Center Designer of creating normal mapping; Moreover there was one new thing came to notice after installation and it was new button at Start Up "Launch Informatica Developer"

This was not available at Informatica 8.6 and prior version. Though I am still not sure what is the exact use of it, but atleast now I am able to log in into it.

At least for 3-4 months I was struggling to find a way to get into it. I had an existing repository and integration service created for Power Centre Designer, however that was not useful for "Informatica Developer". Normal repository which you have created for "Power Center Designer" won't allow you to login at "Informatica Developer"

After doing some trial and error, I noticed that to login at "Informatica Developer" you need to create separate service called "Data Integration Service". 

However, for creation of new Data Integration Service, informatica requires "Model Repository Service" to be created.

So, first step to build the Rome is to have "Model Repository Service" created.

 Click on Action --> New ---> Model Repository Services and a new prompt will appear as below.

First step is pretty simple and here you just have to specify Names and choose the values from drop downs.

Here, you have to select database types and specify userid and password of existing oracle user.

Thought the process seems very simple, I encountered below issues while creating it

1. Error "MRS_50006 Failed to Startup Model Repository Service" --

After googling it, came to know that if you specify same schema which you have used to create other informatica repository, informatica won't allow you to create new "Model Repository Service" there.

So, you need to specify separate schema where there is no Integration Service Installed prior.

2. I had specified "Scott" user instead of HR, as in HR schema there was a old repository service already installed. however, even after specifying new schema I got an error as "DOM 10079" and when I checked the log I got an error description as "user do not have privileges to create an object"

I altered the user by logging via sys user and grant all the privileges to it as below

------------------------------------------------------------------------------

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> grant all privileges to scott;

Grant succeeded.

SQL> exit

------------------------------------------------------------------------------

I again tried to create "Model Repository Service" and this time it got created successfully.

 Now, the remaining task is to create a "Data integration Service" which is a quite easy task.

Once you have "Data Integration Service" in place, try to login at "Informatica Developer"

You will get connected easily into "Informatica Developer". Here after, creating a new mapping using Informatica Developer is a different task and even I am unaware of it as of now.

Will keep posted as soon as I will create a new map using this...