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
Explain why denormalization is promoted in universe designing?
Why fact table is in a normal form?
what are the other factors of the database on which the loading performance depend?
Explain the importance of data warehouse?
What are the difference between snow flake and star schema?
Explain swot analysis?
What are parallel querys and query hints?
What is the difference between mapping parameter & mapping variable in data warehousing?
What is fact less fact table? Where you have used it in your project?
Which component has onread method and what it is used for?
What are the data types present in bo? What happens if we implement view in the designer n report?
How to reduce warnings?
What is the use of tabular model, tabular sql, tabular reference in real time application?
Give some difference between oltp and olap.
List any five applications of data warehouse.