✍ Kashif M
Trends

Tuesday, 28 April 2015

CONFIGURING OUTLOOK FOR WEBMAIL SERVER FOR INFORMATICA 9





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 11.1.1.7.0 installation steps by steps



Before you go for OBIEE 11.1.1.7.0 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 11.1.1.7.0 now. Click on setup file of OBIEE 11.1.1.7.0




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 11.1.1.7.0 Installation









Your OBIEE 11.1.1.7.0 Installation has been completed successfully. OBIEE 11.1.1.7.0 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

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
Connections

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
Browse…

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
mapping

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.


Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) About Kashif (1) BI Apps Installation (1) BI Publisher (2) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) mkashu (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)