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

Sunday, 10 August 2014

Working with mapping in Informatica

By on 05:19:00

Working with Mappings:
You can perform the following tasks with mappings:
  • Create a mapping. When you create a mapping, you save the mapping name in the repository. You can then develop and save the mapping. 
  • Open a mapping. You can open one mapping at a time in a folder.
  • Copy a mapping. You can copy a mapping within the same folder or to another folder.
  • Export a mapping. You can export a mapping to an XML file.
  • Import a mapping. You can import a mapping from an XML file that you exported in the Designer.
  • Edit a mapping. You can add, modify, or delete objects in a mapping.
  • Save a mapping. When you save a mapping in the repository, the Designer performs mapping validation.
  • Debug a mapping. Run the Debugger in the Mapping Designer to test mapping logic.
  • Delete a mapping. Delete a mapping from the repository if you do not want to use it again.  
    Working with mapping in Informatica
    Working with mapping in Informatica
Creating a Mapping:
The first step in the process of moving data between sources and targets is to create a mapping in the Mapping Designer. Use the following steps to create a mapping. To create a mapping:
  • Open the Mapping Designer.
  • Choose Mappings-Create, or drag a repository object into the workspace.
  • Enter a name for the new mapping and click OK.

Opening a Mapping:
To open a mapping, drag it from the Navigator into the Mapping Designer workspace. If you have a mapping in the same folder already open, the Designer prompts you to close it before continuing. Click OK to close the current mapping and open the other one. You can open one mapping at a time in a folder. If you open more than one folder at a time, you can open a mapping in each folder.

Copying a Mapping:
The Designer allows you to copy mappings:
  • Within a folder
  • To another folder in the same repository or in another repository
When you copy a mapping, the Designer creates a copy of each component in the mapping, if the component does not already exist. If any of the mapping components already exist, the Designer prompts you to rename, replace, or reuse those components before you continue.


Post a Comment


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 (1) OBIA (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)