Developer Transformation Guide

10.5
- 10.5.2
- 10.4.1
- 10.4.0

Back Next

Multiple-Occurring Records

You can define multiple-occurring records in the Normalizer transformation source data. Records are groups of fields. Define records in the Normalizer transformation when you need to define groups of source fields that are multiple-occurring.

Multiple-Occurring Records Example

The following Customer row contains customer information with home address information and business address information:


  CustomerID
  FirstName
  LastName
  Home_Street
  Home_City
  Home_State
  Home_Country
  Business_Street 
  Business_City
  Business_State
  Business_Country

When you configure the Normalizer transformation, you can define an input structure that contains the customer fields and a multiple-occurring address record. The address record occurs twice. When you configure the Normalizer transformation output groups, you can return the Address record to a different target than the CustomerID, FirstName, and LastName fields.

The following example shows an input structure with a multiple-occurring address record:

CustomerID
FirstName
LastName
Address (occurs twice)
   Street
   City
   State
   Country

Subrecords are records within records. When you define records and subrecords, you define an input hierarchy of fields in the source row. Each record is a node in a hierarchy that you can reference when you define the transformation output.

For example, the source row might contain multiple phone numbers for each address type:


  CustomerID
  FirstName
  LastName
  Home_Street
  Home_City
  Home_State
  Home_Country
  Telephone_No
  Cell_Phone_No
  Alternate_Phone_No
  Business_Street 
  Business_City
  Business_State
  Business_Country
  Business_Telephone_No 
  Business_Cell_Phone_No 
  Business-Alternate_Phone1

You define an input hierarchy where Address is the parent of Phone. When you define the Normalizer transformation output, you can return the addresses and the phone numbers to separate targets than the customer information.

Define an input hierarchy similar to the following example:

CustomerID 
FirstName 
LastName 
Address  (occurs twice)   
  Street   
  City   
  State    
  Country   
  Phone     
    Telephone_No (occurs three times)

Rename Saved Search

Table of Contents

Developer Transformation Guide

Developer Transformation Guide

Multiple-Occurring Records

Multiple-Occurring Records

Multiple-Occurring Records Example