Application and Database Design Guide

10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.2
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

Generating Composite Keys

To generate a composite key, specify multiple fields in the

Controls

parameter for the

ssan3_get_keys

and

ssan3_get_ranges

calls. SSA-NAME3 concatenates the keys of the fields that you specify to generate a composite key. A composite key can include the keys of up to five fields.

To specify the keys required to generate a composite key, use the

FIELD

control in the following format:

FIELD=Field1,Field2[...,Field5]

For example, to generate keys or ranges for person name and address fields, specify the SSA-NAME3 Person_Name and Address_Part1 fields in the

FIELD

control in the following format:

FIELD=Person_Name,Address_Part1

SSA-NAME3 generates keys for the

Person_Name

and

Address_Part1

fields and concatenates them to build a composite key.

For more information about

ssan3_get_keys

ssan3_get_ranges

calls, see the

Informatica SSA-Name3 API Reference Guide

Composite Keys

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Application and Database Design Guide

Application and Database Design Guide

Generating Composite Keys

Generating Composite Keys