Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 12 April 2015

Building jobs in Informatica Developer 9.6


By on 10:15:00



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.


0 comments:

Post a Comment

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) 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) 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)