OLAP architecture?
OLAP architecture may be
->Generic Two-Level Architecture
->Independent Data Mart
->Dependent Data Mart and ODS
->Logical Data Mart and active Warehouse
->Three-Layer architecture.
For better understanding of these types in detail. please
surf through.
Is This Answer Correct ? | 0 Yes | 1 No |
What is an OLAP (On-line Analytical processing) system?
Ist the schema that a data warehouse system can implements.
How can we do data cleaning?
Compare and contrast aggregates & indexes
What is up date strategy and what are th options for update strategy?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is cost benefit analysis (cba)?
what is the difference between aggregate table and fact table ? how do you load these two tables ?
Do you view contain data?
What is conformed fact?
Explain clustering algorithm?
Explain what is a three tier data warehouse?