Promotion Activity (2.12)
Introduction
A promotion activity copies data from staging tables to their final tables or files, where they can be used by downstream consumers. A promotion activity consists of one or more promotion items, which are to be performed in a specific order. Each promotion item copies data to a final table or file. The data copied can use data from multiple staging tables.
Options
For each promotion item, the following options apply:
-
Promotion Type —Specifies whether the data is to be promoted to a table within this database (that is, the database native to Data Studio) or to an external data target. External targets include other databases, file systems, or supported third-party platforms. The choices are as follows:
-
Internal —This option loads data into a table within this database.
-
External —This option loads data into an external data target. This may be another database, an external file, or a supported platform such as Salesforce.
After you create an item in a promotion activity, you cannot change this setting, and this option is no longer displayed.
-
-
Target Connection — Applies if target is external. Specifies the database or external file system to promote the data into.
After you create an item in a promotion activity, you cannot change this setting.
-
Run Order —Specifies the order in which this item should be executed, relative to other items in the same promotion activity. Select an integer.
-
Description —Specifies an optional description of this item, as an aid to yourself and others reviewing this recipe later.
-
Operation Type Applies if target is external. —Choose one of the following:
-
Insert
-
Insert or Update on Primary Key
-
(Salesforce Only)Upsert
-
-
SQL Expression —Specifies an SQL UPDATE, INSERT, or DELETE statement.
-
Target subfolder Applies if target is a file. —Specifies the subfolder into which the target file should be written. This option is optional. If you omit this value, the file is written to the main directory.
-
Target Filename Pattern Applies if target is a file. —Specifies the name of the file to create. The filename can include the %RUNDATE token, which is replaced with the date and time when the file is created.
-
Target Schema Applies if target is a database, or a structure external schema. —Specifies the name of previously imported data schema, such as a database table definition or a Salesforce object definition.
-
Column Mappings Applies if target is a database. —Maps source columns to fields in the target schema, including database columns or Salesforce object fields. For Salesforce Upsert operations, you must map the object’s external ID field.
-
Delimiter Applies if target is a file. —Specifies the field delimiter. This must be a single ASCII character. To specify a control character, wrap the name of the control character in angle brackets.
-
Line Terminator Applies if target is a file. —Specifies the line terminator to use when creating this file. Use a value appropriate for the target operating system.
