This appendix lists object types and object type properties for the following metadata:
The following tables show the metadata mappings between the Information Catalog Manager and the Data Warehouse Center for each object type. The Information Catalog Manager column shows object type properties as they are displayed in the Description view for an object. The Data Warehouse Center column shows the names of object properties as they are displayed in the various object property notebooks. In some cases, Data Warehouse Center property information (such as processing time stamps for steps) is taken from the Work in Progress window.
| Information Catalog Manager metadata | Data Warehouse Center metadata | ||
| Name | Warehouse source or Warehouse target name | ||
| Short description | Description | ||
| Long description | Notes | ||
| URL to access data | N/A | ||
| Actions | N/A | ||
| Database or subsystem name | Database name | ||
| Database type | The value for this property can be either RELATIONAL or
FILE.
The mapping is derived from the warehouse source or warehouse target type. | ||
| Agent type | N/A | ||
| Database location | N/A | ||
| Database host server name | System name | ||
| System code page | This metadata is internal to the Data Warehouse Center.1 | ||
| Database server type and database extended type. | The mapping is derived from the warehouse source or warehouse target
type.
For example, if your warehouse target is a DB2 Universal Database for Windows NT database, the database server type is DB2 Family. The database extended type is DB2 NT. | ||
| Database owner | N/A | ||
| Timestamp source definition last changed | Last update time stamp for the database definition.
This metadata is internal to the Data Warehouse Center.1 | ||
| Database status | N/A | ||
| Database extended type | Database subtype and database version.
The mapping is derived from the warehouse source or warehouse target type. For example, if your warehouse target is a DB2 Universal Database for Windows NT database, the database extended type is DB2 NT. | ||
| Timestamp source definition created | N/A | ||
| For further information | Administrator | ||
| |||
| Information Catalog Manager metadata | Data Warehouse Center metadata | ||
| Name | Warehouse source name | ||
| Short description | Description | ||
| Long description | Notes | ||
| Actions | N/A | ||
| Database last refreshed | N/A | ||
| For further information | Administrator | ||
| Database owner | N/A | ||
| Database host server name | System name | ||
| Database server type | Database type and database version.
The mapping is derived from the warehouse source type. The property value for IMS DBDs is IMS. | ||
| Database or subsystem name | Datasource name | ||
| Database type | This property is set to HIERARCHICAL.
The mapping is derived from the warehouse source type. | ||
| Database extended type | Database subtype and database version.
The mapping is derived from the warehouse source type. The property value for IMS DBDs is IMS. | ||
| Database status | N/A | ||
| IMS access method | N/A | ||
| Operating system access method | N/A | ||
| Shared index names | N/A | ||
| URL to access data | N/A | ||
| Timestamp source definition created | N/A | ||
| Timestamp source definition last changed | Last update time stamp for the IMS DBD.
This metadata is internal to the Data Warehouse Center.1 | ||
| |||
| Information Catalog Manager metadata | Data Warehouse Center metadata | ||
| Name | Table name | ||
| Short description | Description | ||
| Long description | N/A | ||
| URL to access data | N/A | ||
| Actions | N/A | ||
| Catalog remarks | N/A | ||
| Local database alias | N/A | ||
| Table data last refreshed | Last completed time stamp for a step that ran and used the table as a
target table.
This information is displayed in the Work in Progress window. | ||
| Transformation program type | The value for this property is Data Warehouse Center.
There is no specific metadata in the Data Warehouse Center for this property. | ||
| Database or subsystem name | Database name of the warehouse source or warehouse target database that contains the table | ||
| Table owner | Table schema | ||
| Table name | Table name | ||
| Timestamp source definition last changed | Last update time stamp for a table definition.
This metadata is internal to the Data Warehouse Center.1 | ||
| Base table owner name | N/A | ||
| Base table name | N/A | ||
| Transformation program run mode | N/A | ||
| Transformation program last run | N/A | ||
| Transformation program run frequency | N/A | ||
| Partial or full table copy/update | N/A | ||
| Copied/updated data is in a consistent state | N/A | ||
| Catalog refresh/update frequency | N/A | ||
| Transformation program last changed | N/A | ||
| Transformation program compiled | N/A | ||
| Table type | The mapping is derived from the warehouse source or warehouse target
subtype of the database that contains the table.
For example, if your warehouse source or target is a DB2 Universal Database for Windows NT database, the database table type is DB2 NT. | ||
| Definition represents a view | N/A | ||
| Internal IDS name of table | N/A | ||
| Table is used as a dimension table | Dimension table | ||
| Database host server name | System name of the warehouse source or warehouse target database that contains the table. | ||
| Time stamp source definition created | N/A | ||
| For further information | Administrator of the warehouse source or warehouse target database that contains the table. | ||
| |||
| Information Catalog Manager metadata | Data Warehouse Center metadata | ||
| Name | Column or field name | ||
| Short description | Description | ||
| Long description | N/A | ||
| URL to access data | N/A | ||
| Actions | N/A | ||
| Catalog remarks | N/A | ||
| Datatype of column or field | Data type | ||
| Position of column or field in the primary key | N/A | ||
| Length of the column or field | Length or precision (depending on the data type) | ||
| Scale of the column or field | Scale | ||
| Can column or field be null | Nullable | ||
| Column or field position | Position in the list of columns or fields displayed in the table or file notebook for a warehouse source or warehouse target. | ||
| Database or subsystem name | Database name of the warehouse source or warehouse target that contains the table that contains the column. | ||
| Table owner | Table schema of the table that contains the column. | ||
| Table name | Name of the table that contains the column. | ||
| Containing dimension | N/A | ||
| Column or field name | Column name | ||
| File name | File name of the file that contains the field (Data Warehouse Center files only) | ||
| Byte offset of column or field from start | Offset of this field in a file of fixed type.
This metadata is internal to the Data Warehouse Center.1 | ||
| Is column or field part of a key | N/A | ||
| Is column or field a unique key | N/A | ||
| Is data a before or after image, or computed | N/A | ||
| Source column/field name or expression used to populate column | N/A | ||
| Timestamp source definition last changed | Last update time stamp for the column definition.
This metadata is internal to the Data Warehouse Center.1 | ||
| String used to represent null values | N/A | ||
| Resolutions of dates | N/A | ||
| Precision of column or field | N/A | ||
| Is data text | Is text
The value for this property is Y or N. | ||
| Database host server name | System name of the database that contains the table that contains the column. | ||
| Column or field last refreshed | N/A | ||
| Timestamp source definition created | N/A | ||
| For further information | Administrator for the database that contains the table that contains the column. | ||
| Column ordinality | N/A | ||
| |||
| Information Catalog Manager metadata | Data Warehouse Center metadata | ||
| Name | The value for this property is derived from the file name. | ||
| Short description | Description | ||
| Long description | N/A | ||
| URL to access data | N/A | ||
| Actions | N/A | ||
| Information last refreshed | Last completed time stamp for a step that ran and used the file as a target file. | ||
| Transformation program type | The value for this property is Data Warehouse Center.
There is no specific metadata in the Data Warehouse Center for this property. | ||
| Database host server name | System name of the warehouse source or warehouse target that contains the file. | ||
| Database or subsystem name | Database name of the warehouse source or warehouse target that contains the file. | ||
| File owner | N/A | ||
| File path or directory | The property value for the file path or directory is derived from the file name. | ||
| File name | The property value is derived from the file name. | ||
| File class or type | File type | ||
| Source definition last changed | Last update time stamp for a file definition.
This metadata is internal to the Data Warehouse Center.1 | ||
| Transformation program last run | N/A | ||
| Transformation program run frequency | N/A | ||
| Partial or full file copy/update | N/A | ||
| Copied/updated data is in a consistent state | N/A | ||
| Transformation program last changed | N/A | ||
| Transformation program last compiled | N/A | ||
| Timestamp source definition created | N/A | ||
| For further information | Administrator of the warehouse source or warehouse target that contains the file. | ||
| |||
| Information Catalog Manager metadata | Data Warehouse Center metadata | ||
| Name | Table name | ||
| Short description | Description | ||
| Long description | N/A | ||
| URL to access data | N/A | ||
| Actions | N/A | ||
| Database or subsystem name | Datasource name | ||
| Segment name | N/A | ||
| Segment maximum length | N/A | ||
| Segment minimum length | N/A | ||
| Real logical child segment source | N/A | ||
| Logical parent concatenated key source | N/A | ||
| Transformation program last run | N/A | ||
| Transformation program run frequency | N/A | ||
| Timestamp source definition last changed | Last update time stamp for a segment definition.
This metadata is internal to the Data Warehouse Center.1 | ||
| Database host server name | System name for the IMS database definition (DBD) | ||
| Segment owner | N/A | ||
| Segment last refreshed | N/A | ||
| Timestamp source definition created | N/A | ||
| For further information | Administrator for the IMS DBD that contains the segment. | ||
| |||
| Information Catalog Manager metadata | Data Warehouse Center metadata | ||
| Name | Step name | ||
| Short description | Description | ||
| Long description | N/A | ||
| URL to access data | N/A | ||
| Actions | N/A | ||
| Transformation Identifier | Unique identifier for the transformation.
This metadata is internal to the Data Warehouse Center.1 | ||
| Transformation program name | Program name | ||
| Transformation class or type | Program type | ||
| Source column/field name, expression or parameters | For SQL steps, the value of this property is SQL statement. For non-SQL steps, the value is the concatenation of any Parameter values for the step. | ||
| Source definition last changed | Last update time stamp for step definition.
This metadata is internal to the Data Warehouse Center.1 | ||
| Database host server name | Target database system name | ||
| Transformation owner | N/A | ||
| Source sequence | N/A | ||
| Transformation ordinality | N/A | ||
| Transformation bidirectionality | N/A | ||
| Timestamp source definition created | N/A | ||
| For further information | Administrator | ||
| |||
| Information Catalog Manager metadata | Data Warehouse Center metadata |
| Name | Subject area name |
| Short description | Description |
| Long description | Notes |
| Actions | N/A |
| Data refresh frequency | N/A |
| URL to access data | N/A |
| Filename | N/A |
| For further information | Administrator |
| Information Catalog Manager metadata | Data Warehouse Center metadata | ||
| Name | Warehouse schema name | ||
| Short description | Description | ||
| Long description | Notes | ||
| Actions | N/A | ||
| For further information | Administrator | ||
| URL to access data | N/A | ||
| Timestamp source definition last changed | Last update time stamp for warehouse schema definition.
This metadata is internal to the Data Warehouse Center.1 | ||
| |||
| Information Catalog Manager metadata | Data Warehouse Center metadata | ||
| Name | Process name | ||
| Short description | Description | ||
| Long description | Process notes | ||
| Actions | N/A | ||
| For further information | Administrator | ||
| URL to access data | N/A | ||
| Timestamp source definition last changed | Last update time stamp for the process definition.
This metadata is internal to the Data Warehouse Center.1 | ||
| |||
Table 30 shows the mapping of OLAP server metadata to the Information Catalog Manager common object types. OLAP server metadata refers to metadata for DB2 OLAP Server, DB2 OLAP Integration Server, or Hyperion Essbase Server.
When you publish DB2 OLAP Integration Server metadata to the information catalog, a linked relationship is created between a "dimensions within a multi-dimensional database" object type and a table object.
The left column of the table shows the name of the Essbase API
structure. The right column shows the Information Catalog Manager
object and object type properties.
Table 30. Mapping of OLAP server metadata to the Information Catalog Manager common object types
| OLAP server metadata | Information Catalog Manager metadata |
| Outline | Multidimensional databases |
| Four part name of the OLAP object in the following format: server.application.database.outline | Name |
| Message indicating width and depth limits | Long description |
| OLAP server (part 1 of Name) | Database host server name |
| OLAP database (part 3 of Name) | Database or subsystem name |
| N/A | Database type
The value of this property is MULTIDIMENSIONAL. |
| usOutlineType in ESB_OUTLINEINFO_T | Database extended type
The value for this property can be NORMAL or CURRENCY. |
| N/A | Database status
The value for this property is PRODUCTION. |
| Dimensions in an outline | Dimension within a multidimensional database |
| Dimension alias from EssOtlGetMemberAlias or name | Name |
| OLAP server | Database host server name |
| OLAP database | Database or subsystem name |
| OLAP application | Using application name |
| Dimension name | Dimension name |
| usCategory in ESS_MBRINFO_T | Dimension class or type |
| Members in a dimension | Members within a multidimensional database |
| Member alias from EssOtlGetMemberAlias or name | Name |
| OLAP server | Database host server name |
| OLAP database | Database or subsystem name |
| OLAP application | Using application name |
| Dimension name | Dimension name |
| Member name | Member name |
| last calc string or calc string from EssGetMemberCalc | Derived from |
| usShare in ESS_MBRINFO_T | This property is treated as a shared member (a member with multiple parents). |
Table 31 shows the mapping of DB2 OLAP Integration Server metadata to
Data Warehouse Center metadata.
| DB2 OLAP Integration Server metadata | Data Warehouse Center metadata tag language |
| N/A | SubjectArea - OLAP Cubes |
| OLAP cube name
This property value is the 4-part name in the following format: server.application.database.outline | Process name |
| OLAP cube name
This property value is the 4-part name in the following format: server.application.database.outline | Step name |
| Data source | SourceDataBase (pre-existing in the control database) |
| This property is based on a query of the DB2 OLAP Integration Server catalog (OA_INFO table) based on the following column: PHYSICAL_TABLE. | StepInputTable
A StepInputTable object is created for each table in the source database. |
| This property is based on a query of the DB2 OLAP Integration Server
catalog (OM_INFO table) based on the following columns:
Columns MODEL_NAME and MODEL_IDget MODEL_DATA_SOURCE | DatabaseName |
| This property is based on a query of the DB2 OLAP Integration Server
catalog (OA_INFO table) based on the following columns:
MODEL_NAME and MODEL_ID get PHYSICAL_TABLE Only the name on the right side of the period (without the schema) is used. | TablePhysicalName |
| OLAP cube name
This property value is the 4-part name in the following format: server.application.database.outline | Cube name |
| N/A | StepViewVWPOutputTable |
| OLAP cube name
This property value is the 4-part name in the following format: server.application.database.outline | Step name |
| N/A | VWPProgramTemplate - Build OLAP Cube |
| N/A | VWPProgramTemplateParameter |
| N/A | VWPProgramInstance |
| N/A | VWPProgramInstanceParameter |
| DB2 OLAP Integration Server bat file name | VWPProgramInstanceParameterData |
| N/A | VWP Group - OLAP Integration |