Use this template to define the relationship between a star schema and its input source. This relationship is required for all star schemas.
Table 24 provides information about each token in the
template.
Table 24. SourceDataBase.tag tokens
| Token | Description | Allowed values |
|---|---|---|
| Entity parameters | ||
| *StarSchemaName | The name of the star schema that is being created or related. | A text string. |
| Relationship parameters | ||
| *DatabaseName | The business name of the database that is being created. | A text string. |
| *TableOwner | The owner, high-level qualifier, collection, or schema of the table that
is 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. |
| *CurrentCheckPointID++ | An index, starting with 0, that increases each time it is substituted in
a token.
This token is required. | A numeric value. |
Table 25 provides example values for each token to illustrate the
kind of metadata that you might provide for each token.
Table 25. Example values for SourceDataBase.tag tokens
| Token | Example value |
|---|---|
| *StarSchemaName | Finance schema |
| *DatabaseName | Finance Warehouse |
| *TableOwner | DB2ADMIN |
| *TablePhysicalName | DB2ADMIN.GEOGRAPHY |
| *CurrentCheckPointID++ | 7 |