From Data perspective these 4 layers can be seen in DWH architecture :

DWH architecture?

Question Posted / rb

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

Please Help Members By Posting Answers For Below Questions

How to create different types of templates?

991

What is Discover and Execute in XMLA?

2418

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

2246

Can a dimension table contain numeric values?

1064

What are snapshots? What are materialized views & where do we use them?

1044

Explain differences between star and snowflake schemas?

1163

What is data warehosuing hierarchy?

1179

What is the difference between data warehouse and operational systems?

1147

What is partitioning? What are the types of partitioning?

1173

Explain what is the difference between powerplay transformer and power play reports?

1164

What are the various transformation available?

1017

Explain which are the olap tools available that are supported by oracle?

1012

What is the difference between Datawarehouse and OLAP?

928

What are cluster analysis in data warehousing?

1119

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2504