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

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1557


If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

513


Explain swot analysis?

625


What are the types of SCD?

627


Explain what are components of reportnet?

551






Explain what is partitioning? What are the types of partitioning?

511


Explain why are oltp database designs not generally a good idea for a data warehouse?

624


I need a good brd and uc template?

584


Give some difference between oltp and olap.

591


Explain about core dimension,

536


ware house management system is used?

576


What are target types on the server?

550


what are the major three types of modeling used?

618


What are the advantages and disadvantages of reporting directly against the database?

541


Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

528