<NewRecordBehaviour>

The execution behaviour can be controlled for new records to either INSERT into the target or IGNORE (note: values are case sensitive)

<NewRecordBehaviour type="INSERT" />

Attributes:

type

The type defines the action upon the new record. It can either be "INSERT" or "IGNORE".

INSERT - inserts the record

IGNORE - do nothing to the record

<ChangeRecordBehaviour>

The execution behaviour can be controlled for updated records to either UPDATE into the target or IGNORE (note: values are case sensitive)

<ChangedRecordBehaviour type="UPDATE" />

Attributes:

type

The type defines the action upon the new record. It can either be "UPDATE" or "IGNORE".

UPDATE - updates the record

IGNORE - do nothing to the record

<DroppedRecordBehaviour>

The execution behaviour can be controlled for dropped records to either EXPIRE, DELETE or IGNORE (note: values are case sensitive). EXPIRE is not available for a Salesforce target, but may be used for Cinchy and SqlServer targets. If EXPIRE is selected then an expirationTimestampField must be provided. This is a reference to a date/time column in the target that should be updated with the execution timestamp if the record is dropped.

<DroppedRecordBehaviour
    type="IGNORE"
    expirationTimestampField="string">
    ...
</DroppedRecordBehaviour>

Attributes:

type

The type defines the action upon the dropped record. It can either be "NONE", "EXPIRE", or "DELETE".

IGNORE - records only in the target dataset are not touched

DELETE - records only in the target dataset are deleted

EXPIRE - populates a specified expiration timestamp field as the current time

expirationTimestampField

This attribute is only applicable if the type is equal to "EXPIRE".

The expirationTimestampField is the name of the an existing date field to be filled with the current time.