What is Summary Information?
Summary Information is the area in data warehouse where the predefined aggregations are kept.
Define the functions of a warehouse manager.
The warehouse manager performs consistency and referential integrity checks, creates the indexes, business views, partition views against the base data, transforms and merge the source data into the temporary store into the published data warehouse, backs up the data in the data warehouse, and archives the data that has reached the end of its captured life.
Define a warehouse manager.
Warehouse manager is responsible for the warehouse management process. The warehouse manager consist of third party system software, C programs and shell scripts. The size and complexity of warehouse manager varies between specific solutions.
Define the functions of a load manager.
A load manager extracts data from the source system. Fast load the extracted data into temporary data store. Perform simple transformations into structure similar to the one in the data warehouse.
Define load manager
A load manager performs the operations required to extract and load the process. The size and complexity of load manager varies between specific solutions from data warehouse to data warehouse.
List the phases involved in the data warehouse delivery process.
The stages are IT strategy, Education, Business Case Analysis, technical Blueprint, Build the version, History Load, Ad hoc query, Requirement Evolution, Automation, and Extending Scope.
What is Virtual Warehouse?
The view over an operational data warehouse is known as virtual warehouse.
Explain data mart.
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.
The dimensions are the entities with respect to which an enterprise keeps the records.
How does a Data Cube help?
Data cube helps us to represent the data in multiple dimensions. The data cube is defined by dimensions and facts.