Group items tagged

In metadata, a data steward is a person that is responsible for maintaining a data element in a metadata registry. A data steward may share some responsibilities with a data custodian.

The Data Warehouse Lifecycle Toolkit, by Ralph Kimball et. el., Wiley, 1998, also briefly mentions the role of data steward in the context of data warehouse project management on page 70.

Dr. Kimball explains how Hadoop can be both: A destination data warehouse, and also An efficient staging and ETL source for an existing data warehouse

Building a Hadoop Data Warehouse: Hadoop 101 for EDW Professionals Dr. Ralph Kimball explains how Hadoop can be both a destination data warehouse, and also an efficient staging and ETL source for an existing data warehouse. Learn how enterprise conformed dimensions can be used as the basis for integrating Hadoop and conventional data warehouses.

Fact tables are the foundation of the data warehouse. They contain the fundamental measurements of the enterprise, and they are the ultimate target of most data warehouse queries.

The grain is the business definition of what a single fact table record represents.

the grain is the description of the measurement event in the physical world that gives rise to a measurement.

The choice between deploying relational tables or OLAP cubes is not a trivial matter. Weigh these 34 pros and cons of each approach early in the design of your extract-transform-load system.