HOME BUSINESS METADATA TAXONOMY MGMT DATA GOVERNANCE DATA QUALITY DATA WAREHOUSE BIG DATA BEST PRACTICES ROI

Data Warehouse Metadata

It is a common belief that in order for the data warehouse to be successful, it must be metadata driven.

Our beginnings here at InfoLibrarian™ started with the data warehouse back in the 90's. We knew then and still believe today, that organizations will benefit from a comprehensive view of their metadata, and of metadata management.

InfoLibrarian's software was first released to address the need for metadata for the data warehouse, today; our products address the full range of purposes to deliver reliable metadata, especially for the data warehouse.

Typical Data Warehouse Metadata

Metadata

Source system and target system table mappings.
Destination schema.
Routines and scripts scheduling, mode of running.
Routine version and location.
Automated extract tool settings, if applicable.
Quality reconciliation and control routines.

Dimension Table Management Metadata

Dimensional models.
Dimensional schema info.
Slowly changing dimension policies for each incoming descriptive attribute.
Surrogate key assignment rule and counters.

Transformation and Metadata

Business specifications of the transformation rules.
Source to destination mappings.
Location of the transformation Scripts.
Staging area schema.
Load scripts, schedule and location.

Metadata for Job Control and Audit Logs as well as Documentation

Data lineage and audit records (where exactly did this record come from and when?).
Data Extraction, transform, loading run time logs, success summaries, and time stamps.
Data transform software version numbers.
Security settings for extract files, extract software, and extract metadata.
Security settings for data transmission (i.e., passwords, certificates).
Data staging area archive logs and recovery procedures.
Data staging archive security settings.