PowerExchange for Lotus Notes User Guide for PowerCenter

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

Back Next

Example

The following example shows how the PowerCenter Integration Service loads data into relational targets.

Consider the Test_form1 form with the following fields:

emp_no

emp_name

emp_hiredate

emp_jobs

dept_ids

In the form, emp_jobs and dept_ids are multi-value fields. An employee can be associated with multiple jobs and departments.

The following table shows the sample rows in the Test_form1 form:

emp_no	emp_name	emp_hiredate	emp_jobs	dept_ids
101	John Smith	01/04/1990	Account Manager, Financial Adviser	10, 12
102	Helen Mitchell	08/05/1995	Business Analyst, Consultant	20, 34

The following figure shows a source definition, an Application Source Qualifier, mapplet, and target definitions:

The mapping shows how the PowerCenter Integration Service loads data into relational targets.

In the mapping, the mapplet uses the dynamic Lookup transformation to normalize the multi-value fields.

The following table shows the rows that the PowerCenter Integration Service inserts into dept_ids, where dept_idsKey is the primary key for the target:

dept_idsKey	dept_ids
1	10
2	12
3	20
4	34

The following table shows the rows that the PowerCenter Integration Service inserts into emp_jobs, where emp_jobsKey is the primary key for the target:

emp_jobsKey	emp_jobs
1	Account Manager
2	Financial Adviser
3	Business Analyst
4	Consultant

The following table shows the rows that the PowerCenter Integration Service inserts into employee, where emp_jobsKey and dept_idsKey are the foreign keys for the target:

emp_no	emp_name	emp_jobsKey	emp_hiredate	dept_idsKey
101	John Smith	1	01/04/1990	1
101	John Smith	1	01/04/1990	2
101	John Smith	2	01/04/1990	1
101	John Smith	2	01/04/1990	2
102	Helen Mitchell	3	08/05/1995	3
102	Helen Mitchell	3	08/05/1995	4
102	Helen Mitchell	4	08/05/1995	3
102	Helen Mitchell	4	08/05/1995	4

Rename Saved Search

Table of Contents

PowerExchange for Lotus Notes User Guide for PowerCenter

PowerExchange for Lotus Notes User Guide for PowerCenter

Example

Example