SequenceChecker

Not available in Community Designer

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]  Component sends each data record to all connected output ports.

Icon

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 keyyesKey according to which the records should be sorted. If they are sorted in any other way, graph fails. See Sort Key for more information. 
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, graph fails.Ascending (default) | Descending
Locale Locale to be used when internationalization is set to true. By default, system value is used unless value of Locale specified in the defaultProperties file is uncommented and set to the desired Locale. For more information on how Locale may be changed in the defaultProperties see Chapter 18, Engine Configuration.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 single input port, checks their sort order. If this does not correspond to the specified Sort key, graph fails. If the sort order corresponds to the specified, data records can optionally be sent to all connected output port(s).

See also

Common Properties of Components
Specific Attribute Types
Others Comparison