PowerExchange for Lotus Notes User Guide for PowerCenter

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

Back Next

Multi-value Fields

A multi-value field can store more than one value at a time. The IsMultivalued attribute on the Attributes tab indicates whether the field is a multi-value field.

For example, an EmployeeInfo form contains EmpID, Name, and Phone fields. In this form, the Phone field is a multi-value field.

The following table shows the form fields:

EmpID	Name	Phone
2001	John Smith	408-734-1833, 408-734-1899
2002	Helen Mitchell	650-988-9275, 408-528-8912

You can transfer a multi-value field as text to store it as a single record into the target. The PowerCenter Integration Service inserts the following records into the target:

[2001, John Smith, (408-734-1833, 408-734-1899)]
[2002, Helen Mitchell, (650-988-9275, 408-528-8912)]

You can denormalize a multi-value field to store each value in a multi-value field as a separate record into the target.

The PowerCenter Integration Service inserts the following records into the target:

[2001,John Smith,408-734-1833]
[2001,John Smith,408-734-1899]
[2002,Helen Mitchell,650-988-9275]
[2002,Helen Mitchell,408-528-8912]

Rename Saved Search

Table of Contents

PowerExchange for Lotus Notes User Guide for PowerCenter

PowerExchange for Lotus Notes User Guide for PowerCenter

Multi-value Fields

Multi-value Fields