Developer Transformation Guide

10.2.2 Service Pack 1
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1

Back Next

Input Hierarchy Definition

When you create a Normalizer transformation, you define an input hierarchy that describes records and fields in the source. Define the input hierarchy on the

Normalizer

view of the transformation.

The Developer tool creates the transformation input ports based on the fields that you define in the input hierarchy. Define the input group structure before you define the transformation output groups.

When you define an input hierarchy, you must define an input structure that corresponds to the structure of the source data. The source data might contain more than one group of multiple-occurring fields. To define the structure, you can configure a record that occurs at the same level as another record in the source. Or, you can define records that occur within other records.

Input Hierarchy Example

The following source row contains customer fields and an address record that occurs twice:

CustomerID
  FirstName
  LastName
  Address 
    Street
    City
    State
    Country
  Address1
    Street1
    City1
    State1
    Country1

When you define the input structure in the

Normalizer

view, you can add the CustomerID, FirstName, and LastName as fields. Define an Address record and include the Street, City, State, and Country fields in the address. Change the Address Occurs value to 2.

The following image shows the input hierarchy in the

Normalizer

view:

The

Occurs

column in the

Normalizer

view identifies the number of instances of a field or record in a source row. Change the value in the

Occurs

column for multiple-occurring fields or records. In this example, the customer fields occur one time, and the Address record occurs twice.

The

Level

column in the

Normalizer

view indicates where a field or record appears in the input hierarchy. The customer fields are at level 1 in the hierarchy. The Address record is also level 1.

Normalizer Transformation

Normalizer Transformation Input Ports

Merge Fields

Flatten Fields

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal