DWH architecture?

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


Please Help Members By Posting Answers For Below Questions

Explain why denormalization is promoted in universe designing?

556


Why fact table is in a normal form?

563


what are the other factors of the database on which the loading performance depend?

1502


Explain the importance of data warehouse?

572


What are the difference between snow flake and star schema?

516






Explain swot analysis?

631


What are parallel querys and query hints?

1789


What is the difference between mapping parameter & mapping variable in data warehousing?

559


What is fact less fact table? Where you have used it in your project?

510


Which component has onread method and what it is used for?

514


What are the data types present in bo? What happens if we implement view in the designer n report?

547


How to reduce warnings?

526


What is the use of tabular model, tabular sql, tabular reference in real time application?

520


Give some difference between oltp and olap.

597


List any five applications of data warehouse.

555