The following image shows the field mapping editor.

To the left, the field mapping editor shows the relational fields. To the right, the editor shows the schema elements. In this example, the transformation has two relational groups so you must designate primary and foreign keys. In this example, the

NSId

field is a primary key in the

NewSource

group, and the

NSLeadId

field is the foreign key that links to the

NewSource1

group. The

NS1Id

field is a primary key in the

NewSource1

group.

A primary key is signified by the primary key icon in the

Key

column. A foreign key is signified by the foreign key icon.

To link a relational field to schema element, drag the relational element to the schema element. The

Mapped Field

column shows the relational field to which the schema element is mapped.

If the input relational fields constitute just one group, the data will be treated as denormalized input and there is no need to define primary or foreign keys.