Which of the following table contains the primary information in the data warehouse?
Fact table
A data warehouse is usually modelled with a star (or snowflake) schema, in which one central table is surrounded by several descriptive tables (Kimball; Han and Kamber).
The central fact table holds the primary information of the warehouse: the numeric measures of the business process (sales amount, units sold, profit) together with foreign keys to each dimension. It is by far the largest table and is what queries aggregate.
Dimension tables hold the descriptive context (time, product, store, customer) used to filter and group the facts; they support the analysis but are not the primary data. A lookup table is a small reference table mapping codes to descriptions. Primary table is not a standard data-warehouse term.
Fact table option is correct.
Similar Questions
Fact-less fact table in a data warehouse contains
__________ allows selection of the relevant information necessary for the data warehouse.
__________ system is market oriented and is used for data analysis by knowledge workers including Managers, Executives and Analysts.
A data cube C, has n dimensions, and each dimension has exactly p distinct values in the base cuboid. Assume that there are no concept hierarchies associated with the dimensions. What is the maximum number of cells possible in the data cube, C ?
Match the following :
List - I List - II a. Classification i. Principal component analysis b. Clustering ii. Branch and Bound c. Feature Extraction iii. K-nearest neighbour d. Feature Selection iv. K-means Codes :
Which of the following is characteristic of an MIS ?
Important Questions from Data Warehousing and Data Mining
- Considering the following statements:
A. Data transformation is involved in Datamining process.
B. Online database is used in Data warehouse.
C. Classification is a measure of accuracy.
D. K-means clustering algorithm is based on the concept of minimizing the within-cluster variance.
E. Pattern evaluation is a process to identify knowledge based on interestingness measure.
Choose the correct answer from the options given below: An enormous collection of data on various topics from a variety of internal and external sources, compiled by a firm for its own use or for use by its clients, is called :
Given below are two statements: one is labelled as Assertion A and the other is labelled as Reason R
Assertion A: OLAP systems are optimized for complex queries and analysis.
Reason R: OLTP systems are designed for transactions processing with large read-only queries.
In the light of the above statements, choose the most appropriate answer from the options given below
- Consider the following two statements :
(A) Business intelligence and Data warehousing is used for forecasting and Data mining.
(B) Business intelligence and Data warehousing is used for analysis of large volumes of sales data.
Which one of the following options is correct ? - Consider the following two statements :
(A) Data scrubling is a process to upgrade the quality of data, before it is moved into Data warehouse.
(B) Data scrubling is a process of rejecting data from data warehouse to create indexes.
Which one of the following options is correct ?
