We suppose that you have already learned what is described in:

If you want to find the right Transformer for your purposes, see Transformers Comparison.

Short Summary

Normalizer creates one or more output records from each single input record.

Abstract

Normalizer receives potentially unsorted data through single input port, decomposes input data records and composes one or more output records from each input record.

A transformation must be defined. The transformation uses a CTL template for Normalizer, implements a RecordNormalize interface or inherits from a DataRecordNormalize superclass. The interface methods are listed below.

Icon

Ports

Normalizer Attributes

Legend:

1): One of these must specified. Any of these transformation attributes uses a CTL template for Normalizer or implements a RecordNormalize interface.

See CTL Scripting Specifics or Java Interfaces for Normalizer for more information.

See also Defining Transformations for detailed information about transformations.

CTL Scripting Specifics

When you define any of the three transformation attributes, you must specify the way how input should be transformed into output.

For detailed information about CloudConnect Transformation Language see Part XI, CTL - CloudConnect Transformation Language. (CTL is a full-fledged, yet simple language that allows you to perform almost any imaginable transformation.)

CTL scripting allows you to specify custom transformation using the simple CTL scripting language.

Once you have written your transformation, you can also convert it to Java language code by clicking corresponding button at the upper right corner of the tab.

CTL Templates for Normalizer

The Source tab for defining the transformation looks like this:

Figure 55.4. Source Tab of the Transform Editor in the Normalizer Component

function integer count() {
   customers = split($0.customers,"-");
   return length(customers);
}

function integer transform(integer idx) {
   myString = customers[idx];
   $0.OneCustomer = str2integer(myString);
   $0.RecordNo = $0.recordNo;
   $0.OrderWithinRecord = idx;	
   return OK;
}

function void clean() {
   clear(customers);
}

function integer countOnError(
                  string errorMessage, 
                  string stackTrace) {
   printErr(errorMessage);
   return 1;
}

function integer transformOnError(
                  string errorMessage, 
                  string stackTrace, 
                  integer idx) {
   printErr(errorMessage);
   printErr(stackTrace);	
   $0.OneCustomerOnError = customers[idx];
   $0.RecordNo = $recordNo;
   $0.OrderWithinRecord = idx;	
   return OK;
}

	Important
	Input records or fields Input records or fields are accessible within the count() and countOnError() functions only. Output records or fields Output records or fields are accessible within the transform() and transformOnError() functions only. All of the other CTL template functions allow to access neither inputs nor outputs.

	Warning
	Remember that if you do not hold these rules, NPE will be thrown!

Java Interfaces for Normalizer

The transformation implements methods of the RecordNormalize interface and inherits other common methods from the Transform interface. See Common Java Interfaces.

Following are the methods of RecordNormalize interface: