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 are the tools available for etl?
How many ways we test the universe & Report?
What is cost benefit analysis (cba)?
What is Conceptual, Logical and Physical model?
What is the use of incremental aggregation? Explain me in brief with an example?
What is metadata in context of a datawarehouse and how it is important?
What are session timeout and application timeout? Where we have to do this process?
What is data type of the surrogate key?
What are the main steps to build the data warehouse?
What is the difference between datawarehouse and bi?
5.Explain ODS ?
Explain the difference between oltp and olap?