✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


Tuesday, 28 April 2015


Step by step procedure to configure Outlook for webmail server to send e-mails from Informatica.

Step1: Go to Outlook. (Pic shown below)

Outlook -> File -> Account Settings

Step2: In Account Settings, add Sender and Recipient E-mail accounts.

Select "Sender Email Account", and click on "Set as Default"

Step3: Double-click on the "Sender Account", give the details as shown.

Step4: Click on "More Settings".

In "Advanced" tab, give the details as show in the pic below.

In "Outgoing Server" tab, give the details as show in the pic below.

Step5: Add Outlook Data Files as shown below.

Step6: Create a distribution list with all the recipient e-mail ids, in the outlook address book.

Step7: Go to Informatica Administration Console.

Click on "Domain" and go to Properties.

Give the "SMTP Configuration" details as shown below.

Step8: Select the required Integration Service.

Go to Properties and add the "SMTP Configuration" details under "Custom Properties"

OBIEE installation steps by steps

Before you go for OBIEE installation you need create schema from RCU (Repository creation utility)

Follow the same step as per the screen shot.

Click on create and load component schema into a database

Give hostname, port, service name and sys username password to create schema

It will do pre-check and give on OK

Select AS Common schemas and Oracle Business Intelligence

Click Ok

Give common password

Click on OK

Click on OK

Click on OK

Click on Ok

Click on Create

By this your Repository has been created.

Start Installing OBIEE now. Click on setup file of OBIEE

Give Next

Check on Skip Software Updates

Give Next

Go with Enterprise Install

Hit the password and give next

Select some empty directory and give next

Give Yes and hit on Enter

Give next

Give Database credentials and hit on enter

Give Database credentials and hit on enter

Select Auto Port configuration and hit enter

Give next

Click on Install

Click on Next

Hit on Finish you are done OBIEE Installation

Your OBIEE Installation has been completed successfully. OBIEE is ready for use.

Sunday, 12 April 2015

Building jobs in Informatica Developer 9.6

Creating a mapping and executing it in new platform is conceptually the same as PowerCenter, though the user interface varies quite a bit. we look at all the steps required to create a mapping and successfully execute it in the new platform.


Connections can be created in PowerCenter Administrator web console that can be used in the Developer tool. Follow the steps given below to create a connection in the administrator: 

a. Go to Administrator console

 b. Go to Domains tab àConnections sub tab

c. Right click the domain name 

d. Select the connection database type (such as Oracle)

 e. Provide username, password, connection string details and click Finish

Physical data objects Just like in PowerCenter, to begin developing a mapping, we need to
import the source and target definitions first. These are known as Physical
Data Objects (PDOs).

a. Connect to the Model Repository

b. Open the project where you would like to create a mapping 

c. Ensure connections are already created d. Add the connections in the
developer tool 

1. In the Connection Explorer, right click à Click Select

2. Select Connections dialog box appears

3. In the available connections, expand the domain and select a
connection and click ">"

4. Connection will be added to selected connections. Click OK
to close the dialog

5. Connection will appear in the Connection Explorer

e. Create a new physical data object for source

 1. Right click on the project/folder and click NewàData Object

2. New Wizard appears

3. Select Physical Data ObjectàRelational Data Object

4. Select a connection, where this object (table) exists 5.
Select Create data object from existing resource and click

6. Select the table you want the object to be associated with 7.
Click Finish to save the physical data object

f. Create a new physical data object for target

Creating a mapping

Before a mapping is created, ensure that you have setup connections and have imported the physical data objects into model repository. To create a mapping, follow these steps:

a. Connect to model repository

b. Open the project where you want to create the mapping c. Create a

1. Right click on the project/folder and click NewàMapping

2. Provide a name to the mapping and click Finish

d. Drag the source and target

1. Drag the source from the object explorer into the mapping

2. Add to mapping dialog box appears

3. Select ReadàAs Independent data object(s)

4. Click OK to close the dialog

5. The PDO is added with Read_ prefix in the name

e. Drag the target

1. Drag the target from the object explorer into the mapping

2. Add to mapping dialog box appears

3. Select Write and click OK to close the dialog 

4. The PDO is added with Write_ prefix in the name

f. Connect the ports from the source to the target g. Save the mapping

Mapping execution
Once the mapping is saved, right click on the workspace and click Run Mapping. If you are running mapping for the first time in this domain, you will be prompted to set a default Data IntegrationService. Click OK. In the Data Integration Services dialog box, select a data integration service andclick Set as Default and click OK to close. Mapping will run.