Summary Information is the area in data warehouse where the predefined aggregations are kept.
The dimensions are the entities with respect to which an enterprise keeps the records.
Metadata is simply defined as data about data. In other words, we can say that metadata is the summarized data that leads us to the detailed data.
Data mart contains the subset of organization-wide data. This subset of data is valuable to specific groups of an organization. In other words, we can say that a data mart contains data specific to a particular group.
A data Warehouse can implement star schema, snowflake schema, and fact constellation schema.
There is only one fact table in a star Schema.
The view over an operational data warehouse is known as virtual warehouse.
Some applications include financial services, banking services, customer goods, retail sectors, controlled manufacturing.
Metadata respiratory contains definition of data warehouse, business metadata, operational metadata, data for mapping from operational environment to data warehouse, and the algorithms for stigmatization.