Promotion Activity (2.8)
Introduction
A promotion activity copies data from staging tables to their final tables, 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. 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 InterSystems TotalView For Asset Management) or to a table in another database. The choices are as follows:
-
Internal—This option loads data into a table within this database.
-
External—This option loads data into a table in another database.
After you create an item in a promotion activity, you cannot change this setting, and this option is no longer displayed.
-
-
Target Database—Specifies the database to promote the data into. (Applies if Promotion Type is External).
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.
-
SQL Expression—Specifies an SQL UPDATE, INSERT, or DELETE statement that affects the final table.