What are measures?
Measures are numeric data based on columns in a fact table. They are the primary data which end users are interested in. E.g. a sales fact table may contain a profit... Read more »
‘Datawarehousing Interview Questions’ - KyaPoocha.com
What are cubes?
Cubes are data processing units composed of fact tables and dimensions from the data warehouse. They provide multidimensional views of data, querying and analytical... Read more »
What is Clustering?
Clustering. Sometimes called segmentation, clustering identifies people who share common characteristics, and averages those characteristics to form a “characteristic... Read more »
What is Market Basket Analysis?
Processing transactional data in order to find those groups of products that are sold together well. One also searches for directed association rules identifying... Read more »
Give reasons for the growing popularity of Data Mining.
Reasons for the growing popularity of Data Mining Growing Data Volume The main reason for necessity of automated computer systems for intelligent data analysis is... Read more »
What is Memory Based Reasoning (MBR)?
To forecast a future situation, or to make a correct decision, such systems find the closest past analogs of the present situation and choose the same solution which... Read more »
What is SKAT?
Symbolic Knowledge Acquisition Technology (SKAT). A system based on SKAT develops an evolving model from a set of elementary blocks, sufficient to describe an arbitrarily... Read more »
What is active data warehousing?
An active data warehouse provides information that enables decision-makers within an organization to manage customer relationships nimbly, efficiently and proactively.... Read more »
What is the difference between view and materialized view?
View - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes. Materialized View - stores... Read more »
What are non-additive facts in detail?
A fact may be measure, metric or a dollar value. Measure and metric are non additive facts. Dollar value is additive fact. If we want to find out the amount for... Read more »
What are types of Facts?
There are three types of facts: * Additive: Additive facts are facts that can be summed up through all of the dimensions in the fact table. * Semi-Additive: Semi-additive... Read more »
Give the two types of tables involved in producing a star schema and the type of data they hold.
Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables. Read more »