Transformation Guide

Back Next

Status Code Values and Status Description Values

The persistence status codes and the persistence status descriptions describe the relationship between the transformation input records and the records that the data store represents. The transformation uses sequence identifier values to identify the records and to determine the relationship between the records in the data sets.

The persistence status code and the persistence status descriptions have a common structure. The status codes and the status descriptions contain the same information at each position in the output data string.

Data Set Status

The first value in the status code and in the status description identifies the data set that contains the record.

The following table describes the status codes and the status descriptions that the transformation can return in the first position:

Status Code	Status Description
S	Store. The current record originates in the index data store.
I	Input. The current record originates in the transformation input data.

Duplicate Record Status

The second value in the status code and in the status description describes the relationship between the transformation index data and the persistent data store.

The following table describes the status codes and the status descriptions that the transformation can return in the second position:

Status Code	Status Description
A	Absent. The index data store does not contain data for the current record.
E	Exists. The current record is present in the index data store and in the transformation input data.
I	Invalid. The transformation cannot analyze the current record. For example, the transformation cannot generate index data for the record because the key field on the Match Type tab is not compatible with the record data.
N	New. The record is present in the data source.
0	[Dash] The record is present in the index data store.

Data Store Status

The third value in the status code and in the status description describes any action that the transformation performs on the index data tables.

The following table describes the status codes and the status descriptions that the transformation can return in the third position:

Status Code	Status Description
A	Added. The transformation adds the index data for the current input record to the persistent data store. The transformation input data and the persistent index data have different sequence identifiers.
I	Ignored. The transformation does not add any index data for the current input record to the persistent data store.
N	The transformation returns one of the following descriptions: No change. The current record originates in the persistent data store, and the transformation takes no action. Not added. The transformation does not update the persistent data store with any data for the current input record because of the match policy that you defined.
R	Removed. The transformation removes the index data for the record from the index data store.
U	Updated. The transformation updates the rows in the persistent data store with index data from the transformation input record. The transformation input data and the persistent index data have common sequence identifiers.

Persistence Status Description Example

The persistence status code INA00000 has the following persistence status description:

Input, New, Added

The status code and the status description contain the following information about the record:

The record originates in the transformation input data.

The persistent data store does not contain a copy of the record.

The transformation adds the index data for the record to the persistent data store.

Rename Saved Search

Table of Contents

Transformation Guide

Transformation Guide

Status Code Values and Status Description Values

Status Code Values and Status Description Values

Data Set Status

Duplicate Record Status

Data Store Status

Persistence Status Description Example