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 |
Can we have multiple application.cfm file in an application?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain what is a view as it relates to system modeling?
What is difference macros and prompts?
Explain what is data validation strategies for data mart validation after loading process?
How to use the tool Ontobulider
How to performance tune reports?
What is the difference between a W/H and an OLTP application?
Explain what is the advantages data mining over traditional approaches?
Explain difference between snow flake and star schema.
What is the main difference between star and snowflake star schema? Which one is better and why?
Describe a data warehouse.