Id

String

No

Step identification string.

Primary Key Column

String

No

Column or expression containing a unique primary key of records. Used and required only in incremental mode and when identify = false.

Minimum Id To Assign

Long

Yes

Minimal value for newly assigned group ids. This parameter is related to all unification operations, which may assign new unique ids to candidate or client groups during processing. The real last assigned id is always stored in the repository and this value is only the lower limit for newly assigned ids. Default value: 1.

Batch Mode

Boolean

Yes

Specifies processing mode with parallel processing disabled. In this mode only one batch can be processed at a time. Default value: False.

Processing Mode

Processing Mode

Yes

Specifies processing mode.

Data Source

String

No

Name of the data source for connection to the database containing the repository. Mandatory when processingMode is not NONINCREMENTAL.

Repository Name

String

No

Name of the repository determining the table names in the database. Mandatory when processingMode is not NONINCREMENTAL.

Export Changed Only

Boolean

Yes

Send only changed records to the output. Default value: False.

Export Discarded

Boolean

Yes

Send discarded records to the output. Discarded records are: Default value: False.

• Records with an empty or duplicate primary key
• Records with a timestamp that is older than the repository

Read Only

Boolean

Yes

Specify that the repository will not be updated. Default value: False.

Delete Flag Column

String

No

Boolean column or expression indicating whether the record must be removed from the repository.

Timestamp Column

String

No

Datetime column or expression containing an optional last record update time.

Changed Flag Column

String

No

String column for storing a flag indicating if and how the record has changed in the repository. The flag can have the following values: If not specified, discarded older records which would obtain the flag "X", are not sent to the output.

• A - input record added to the repository
• U - input record updated in the repository
• D - input record deleted from the repository
• R - reloaded record changed in the repository
• N - reloaded record which has not changed
• I - identified input record (when processionMode=IDENTIFY)
• X - input record which is older than its repository image and has been discarded
• Y - input record which has an empty or duplicate primary key and has been discarded

Changed Timestamp Column

String

No

Datetime column for storing the time stamp when the record was written to the repository.

Operations

List of I Incremental Client Config

No

List of operations.

Map All Columns

Boolean

Yes

Specifies that all columns of input record format will be stored in the repository. Property repositoryColumns must be empty when true. Default value: True.

Repository Columns

List of Column Ref

No

List of columns stored in the repository. At least all columns needed for unification must be present.