Use this template to define the relationship between a step and its output target.
This relationship is required for steps of type ISV_StepType_Editioned_Append, ISV_StepType_Full_Replace, ISV_StepType_Uneditioned_Append.
Table 32 provides information about each token in the
template.
Table 32. SourceDataBase.tag tokens
| Token | Description | Allowed values |
|---|---|---|
| Entity parameters | ||
| *StepName | The name of the step that is being created or related. | A text string. |
| Relationship parameters | ||
| *DatabaseName | The business name of the database that is being related. | A text string. |
| *TableOwner | The owner, high-level qualifier, collection, or schema of the table being
described.
This value must be a valid qualifier as defined by the rules of ODBC. | A text string. |
| *TablePhysicalName | The physical table name as it is known to ODBC (the system DSN name). | A text string. |
| *ProcessName | The name of the process that is being related. | A text string. |
| *CurrentCheckPointID++ | An index, starting with 0, that increases each time that it is
substituted in a token.
This token is required. | A numeric value. |
Table 33 provides example values for each token to illustrate the
kind of metadata you might provide for each token.
Table 33. Example values for StepOutputTable.tag tokens
| Token | Example value |
|---|---|
| *StepName | Revenue by product |
| *DatabaseName | Finance Warehouse |
| *TableOwner | FINADMIN |
| *TablePhysicalName | INVENTORY |
| *ProcessName | Marketing process |
| *CurrentCheckPointID++ | 4 |