DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Application level metadata.
|
|
|
Algorithmic level metadata.
|
|
|
Departmental level metadata.
|
|
|
Core warehouse metadata.
|
Detailed explanation-1: -What is held in the catalog of the warehouse database system? Answer-A) Algorithmic level metadata is held in the catalog of the warehouse database system.
Detailed explanation-2: -Metadata is simply defined as data about data. The data that is used to represent other data is known as metadata. For example, the index of a book serves as a metadata for the contents in the book. In other words, we can say that metadata is the summarized data that leads us to detailed data.
Detailed explanation-3: -Types of Metadata Metadata in a data warehouse fall into three major parts: Operational Metadata. Extraction and Transformation Metadata. End-User Metadata.
Detailed explanation-4: -Which of the following maps the core warehouse metadata to business concepts, familiar and useful to end-users. Answer-B) Application-level metadata maps the core warehouse metadata to business concepts.
Detailed explanation-5: -Explanation: Metadata Describes the data contained in the data warehouse.