The Mapping Designer tool is part of Informatica’s Designer client application. You use it to map data from source to target. The target tables are the ETL staging tables that reside on the Connect database.
The Mapping Designer lets you select from two views: Iconic view and Table view.
Iconic View:
Table View:
Mapping Guidelines:
- Every mapping session must have a Source Qualifier transformation that extracts the data from the source.
- You can also use additional transformations to manipulate the data if desired, based on your business requirements.
- Mappings can be one-to-one (one source to one target), many-to-one (multiple sources to one target), or one-to-many (one source to multiple targets).
- In the Mapping Designer, the flow of data is represented by connecting arrows.
- Open the Start menu on your desktop and choose Programs, Informatica , Designer.
- In the Designer window, select the Mapping Designer tool.
- Choose Mapping, Create Mapping from the menu bar.
- Drag and drop source(s) from the Navigator bar.
- Drag and drop target(s) from the Navigator bar.
- Select any desired transformation(s) from the Transformation bar (by pointing and clicking).
- Create ports and enter expressions for the transformations you selected.
- Connect the ports from the Source Qualifier, through all the transformations, and then to the target.
When you create a mapping for the ETL_CUSTOMER_MASTER table, you must use the customer e-mail address (or the alternate customer id) as the unique identifier. Every customer must have an e-mail address or, if you prefer, an alternate customer id. The Connect database requires that you use either email_address or alt_customer_id as the primary key.