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
Describe the differences between a data warehouse and data mart.
What is dimensional modelling?
What is the difference between metadata and data dictionary?
Explain the definition of normalized and denormalized view and what are the differences between them?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Explain vldb?
How to generate the cubes in framework manager?
What is core dimension?
Explain why fact table is in normal form?
How can we do data cleaning?
What are the different types of datawarehosuing?
What is data type of the surrogate key?
What are partition points?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain what is metadata reporter?