This chapter provides detailed information about each template that is provided with the Data Warehouse Center and the Information Catalog Manager. The section for each template lists the tokens for the template. It provides the allowed values and lengths of values for each token.
If your interchange program does not have a value for a token, it should set the token to ISV_DEFAULTVALUE. However, you must specify a value other than ISV_DEFAULTVALUE for any token that is required.
Because there is no template for security groups, your program must specify the value ISV_DEFAULTSECURITYGROUP for any instances of the *SecurityGroup token.
If the template does not set a Data Warehouse Center parameter, the Data Warehouse Center definition will have the default value of the parameter. For example, the Data Warehouse Center sets the Retry Count and Retry Interval parameters for source databases to their default values.
Table 13 lists the metadata templates that are supplied with the Data
Warehouse Center and the section that covers each template.
Table 13. Metadata templates supplied with the Data Warehouse Center
| Template | Description | See: |
|---|---|---|
| AgentSite.tag | Defines an agent site from which the agent accesses the data source or target warehouse, or on which a Data Warehouse Center program runs. | "AgentSite.tag" |
| Column.tag | Defines a column or field in a table, segment, or file. | Column.tag |
| HeaderInfo.tag | Declares all the object type definitions needed by the Data Warehouse Center to declare a tag language file. | HeaderInfo.tag |
| Process.tag | Defines a process. | Process.tag |
| StarSchema.tag | Defines a star schema. | StarSchema.tag |
| StarSchemaInputTable.tag | Defines the relationship between tables and a star schema. | StarSchemaInputTable.tag |
| Step.tag | Defines a step. | Step.tag |
| StepCascade.tag | Defines a cascade relationship between steps. | StepCascade.tag |
| StepInputTable.tag | Defines the relationship between a step and its source tables. | StepInputTable.tag |
| StepOutputTable.tag | Defines the relationship between a step and its target. | StepOutputTable.tag |
| StepVWPOutputTable.tag | Defines the relationship between a step and a warehouse target. | StepVWPOutputTable.tag |
| StepVWPProgramInstance.tag | Defines an instance of a specific template used by a step. | StepVWPProgramInstance.tag |
| SourceDataBase.tag | Defines a warehouse source. | SourceDataBase.tag |
| SubjectArea.tag | Defines a subject area to contain the processes and steps being created. | "SubjectArea.tag" |
| Table.tag | Defines a table or file that the Data Warehouse Center is to access. | Table.tag |
| VWPGroup.tag | Defines a group that is to contain any Data Warehouse Center program being defined. | VWPGroup.tag |
| VWPProgramInstanceParameter.tag | Adds or modifies a parameter that the Data Warehouse Center passes to an instance of a Data Warehouse Center program used by a specific step. | VWPProgramInstanceParameter.tag |
| VWPProgramTemplate.tag | Defines a Data Warehouse Center program. | VWPProgramTemplate.tag |
| VWPProgramTemplateParameter.tag | Defines a parameter that the Data Warehouse Center is to pass to a Data Warehouse Center program. | VWPProgramTemplateParameter.tag |
| WarehouseDataBase.tag | Defines a warehouse target. | WarehouseDataBase.tag |