Answer Posted / rb
From Data perspective these 4 layers can be seen in DWH
architecture :
Staging
Atomic or Base layer,
Aggregate layer,
Presentation layer
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How did you plan your Data ware house project?
What is a core dimension?
Explain what is type 2 version dimension?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is fact less fact table? Where you have used it in your project?
What is metadata in context of a datawarehouse and how it is important?
What is the goal of optimizer?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What are algorithms provided by Microsoft in SQL Server?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is surrogate key? Where we use it?
What are loops in Datawarehousing?
What is Star Schema?
Explain differences between star and snowflake schemas?