Answer Posted / pradeeshkumar
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 |
Post New Answer View All Answers
Explain a relation schema and a relation?
Explain the difference between view and materialized view?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What is an er diagram?
Explain what are the tasks that loadmanger process will do?
What is pre-emptive and non-pre-emptive?
Describe the differences between a data warehouse and data mart.
What is called data cleaning?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain piconet?
Explain normalization?
Explain where do we use semi and non additive facts?
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 needs to be done while starting the database?
What are the advantages of query studio compared to report studio?