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 | ||
| |||