PowerExchange for Lotus Notes User Guide for PowerCenter

10.5.4
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5
- 10.4.0

Back Next

Creating Lotus Notes Mappings

Convert a Lotus Notes source definition into a relational model for normalization. The relational model is based on the star schema that contains a central fact table and the tables associated with multi-value fields. The tables have the primary-key foreign-key relationship with the fact table.

In the Mapping Designer, click Mappings > Generate Normalized Lotus Notes Mapping.

The Normalize Lotus Notes Source dialog box appears.

Select a source definition from the Select Source Table list.

Enter a name for the target definition.

Oracle is default target database type. You can use the Target Designer to change the default target database type.

Click OK.

The Mapping Designer generates a mapplet and target definitions. The mapplet uses the dynamic Lookup transformation to normalize data. The names of the multi-value field tables correspond to the multi-value field names in the Lotus Notes source definition.

Link the source definition to the mapplet.

Lotus Notes Mappings

Example

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal