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 |
wht is degenerated dimension ?it's uses?
What is META DATA information in Data warehousing projects?
What is the differences between star and snowflake schemas?
What are the different methods of loading dimension tables?
What needs to be done when the database is shutdown?
What is Drill by? drill through?
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
What is the function of surrogate key in data warehousing?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is operational data source (ODS)?
What is the difference between junk dimension and degenerated dimension?
What function should we use to display the value entered or selected by a user in response to a prompt?