Information Catalog Manager Administration Guide

Metadata Mappings between the Information Catalog Manager and the Data Warehouse Center

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.


Table 18. Metadata mappings between the Information Catalog Manager and the Data Warehouse Center for database objects
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
Note:
  1. If a property is specified as internal to the Data Warehouse Center, it is not displayed.

Table 19. Metadata mappings between the Information Catalog Manager and the Data Warehouse Center for IMS DBD (database description definition) objects
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

Note:
  1. If a property is specified as internal to the Data Warehouse Center, it is not displayed.

Table 20. Metadata mappings between the Information Catalog Manager and the Data Warehouse Center for relational table or view objects
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.
Note:
  1. If a property is specified as internal to the Data Warehouse Center, it is not displayed.

Table 21. Metadata mappings between the Information Catalog Manager and the Data Warehouse Center for column or field objects
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
Note:
  1. If a property is specified as internal to the Data Warehouse Center, it is not displayed.

Table 22. Metadata mappings between the Information Catalog Manager and the Data Warehouse Center for file objects
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.
Note:
  1. If a property is specified as internal to the Data Warehouse Center, it is not displayed.

Table 23. Metadata mappings between the Information Catalog Manager and the Data Warehouse Center for IMS segment objects
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.
Note:
  1. If a property is specified as internal to the Data Warehouse Center, it is not displayed.

Table 24. Metadata mappings between the Information Catalog Manager and the Data Warehouse Center for transformation objects
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
Note:
  1. If a property is specified as internal to the Data Warehouse Center, it is not displayed.

Table 25. Metadata mappings between the Information Catalog Manager and the Data Warehouse Center for business subject area objects
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

Table 26. Metadata mappings between the Information Catalog Manager and the Data Warehouse Center for star schema objects
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

Note:
  1. If a property is specified as internal to the Data Warehouse Center, it is not displayed.

Table 27. Metadata mappings between the Information Catalog Manager and the Data Warehouse Center for Data Warehouse Center process objects
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

Note:
  1. If a property is specified as internal to the Data Warehouse Center, it is not displayed.


[ Top of Page | Previous Page | Next Page ]