g_ETLPipelineSteps_UpsertCommand

UpsertCommand

Use the Upsert command to update an existing object or create a new one from the data that you are processing.

Properties

attributeMapping : string

The attribute mapping for the input attribute names.

Example: '((firstName firstName1) (homeAddress homeAddress1))

attributes : string

The list of class attributes whose values you want to specify using the data. Used for the insert case.

You can only specify attributes of the class you are instantiating. You cannot specify attributes of associated classes. That is, you cannot specify the details of a complex attributes.

Example: Specifying '(firstName homeAddress) indicates that you will use the data to specify values of the firstName and homeAddress attributes of the class.

caption : string

String identifier for caption display in the UI.

class : string

The class type to upsert from the data.

Example: If you want to use the data to upsert an instance of the Person class, specify "Person".

description : string

A description for this Upsert command. This text is displayed as an element note in the ETL diagram.

eventless : boolean

True (default) to disable event firing for the instances that are created or updated.

input : string

The name of the cursor that the command will access to receive its data.

key : string

The list of attributes to act as the key for comparing records when checking if a record already exists.

If not specified, the default key for the object type will be used.

Example: Both '(firstName homeAddress) and '(firstName (homeAddress city)) are valid.

layout : string

This attribute captures the UI layout information for rendering the model in the editor. The values change as users moves the element in the editor.

name : string

The cursor name. This name is diplayed on the ETL diagram.

updateAttributes : string

The list of class attributes whose values you want to specify using the data. Used for the update case. If unspecified of null, then "attributes" will be used.

You can only specify attributes of the class you are instantiating. You cannot specify attributes of associated classes. That is, you cannot specify the details of a complex attributes.

Example: Specifying '(firstName homeAddress) indicates that you will use the data to specify values of the firstName and homeAddress attributes of the class.

Parents

g_ETLActivitySteps_ETLPipeline - Pipelines gather and group cursors and commands together into related units, becoming the defining blocks of your ETL activities.

Parent topic: g_ETLActivitySteps_ETLPipeline