SequenceChecker

Short Description
Ports
Metadata
SequenceChecker Attributes
See also

Short Description

SequenceChecker checks the sort order of input data records.

Component Same input metadata Sorted inputs Inputs Outputs Each to all outputs [1] Java CTL Auto-propagated metadata
SequenceChecker-
no
11-n
yes
no
no
yes

[1]  The component sends each data record to all connected output ports.

Ports

Port typeNumberRequiredDescriptionMetadata
Input0
yes
For input data recordsAny
Output0-n
no
For checked and copied data recordsInput 0 [1]

[1]  If data records are sorted properly, they can be sent to the connected output port(s).

Metadata

All metadata must be the same.

Metadata can be propagated through this component.

SequenceChecker Attributes

AttributeReqDescriptionPossible values
Basic
Sort keyyes

A key according to which the records should be sorted. If they are sorted in any other way, graph fails. For more information, see Sort Key.

 
Unique keys 

By default, values of Sort key should be unique. If set to false, values of Sort key can be duplicated.

true (default) | false
Equal NULL 

By default, records with null values of fields are considered to be equal. If set to false, nulls are considered to be different.

true (default) | false
Deprecated
Sort order 

Order of sorting (Ascending or Descending). Can be denoted by the first letter (A or D) only. The same for all key fields. Default sort order is ascending. If records are not sorted this way, the graph fails.

Ascending (default) | Descending
Locale 

Locale to be used when internationalization is set to true. By default, a system value is used unless the value of Locale specified in the defaultProperties file is uncommented and set to desired Locale. For more information on how Locale may be changed in the defaultProperties, see Chapter 18, Engine Configuration.

a system value or specified default value (default) | other locale
Use internationalization 

By default, no internationalization is used. If set to true, sorting according national properties is performed.

false (default) | true

Details

SequenceChecker receives data records through its single input port and checks their sort order. If this does not correspond to the specified Sort key, the graph fails. If the sort order corresponds to the specified Sort key, data records can optionally be sent to all connected output port(s).