Element Details: Load+SimpleDB.Upsert
 Back


Available in: Logi Info Source code name: LoadSimpleDB.Upsert

Updates or inserts a row in a SimpleDB domain. A row is inserted when there are no items matching the Item Name. Otherwise, a row is updated.

Setting the EtlElementID attribute to the ID of an earlier Extract or Transform element determines which datalayer is loaded into the destination tables. If the EtlElementID is not specified, then the Load element will attempt to use the last Extract or Transform datalayer generated.

You can reference the number of rows affected with an ETL token.

For Example:
@Etl.myLoadID.rdRowsAffected~

Element Group:Load Data Elements



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ConnectionID
UserDefined
(Required) Specifies a connection to a data source that is defined in the Settings. For elements connecting to relational databases, default is the first Connection element in _settings.lgx.
EtlElementID
UserDefined
Enter the ID of the Extract or Transform element that contains the data to be processed. If this attribute does not have a value, then the system will use the data from the last Extract or Transform element.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
SimpleDBDomain
UserDefined
(Required) The name of the SimpleDB domain (similar to a table).
SimpleDBItemName
UserDefined
(Required) The value of the Item Name, the unique identifier for a record in a SimpleDB domain.



PARENT ELEMENTS

Click element to drill down for more information.

Etl Job
If 		If ETL Error
If File Exists 		If Folder Exists Loop.Data Layer Rows


CHILD ELEMENTS

Click element to drill down for more information.

Column Map If ETL Error


 Back to top


Chart Debug