DWH architecture?

Answer Posted / sowmi

DWH Architecture:

It has 3 layers:

1.Staging
2.Integration
3.Target

In staging we get the raw data.In integration we process i.e
we cleanse the data.In target the data is ready to be used
by end users for report generation.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

530


What are the possible data marts in retail sales?

534


What are the types of dimensional modeling?

612


Explain what is analytical or analytic mean?

581


Explain what are necessary tasks to install reportnet software?

479






How to export mappings to the production environment?

502


Can you brief about the Data warehouse project you worked on?

1947


What are partition points?

563


Explain what is the data type of the surrogate key?

577


Why we use repository connectivity?

540


Can we take backup when the database is opened?

580


What is the very basic difference between data warehouse and operational databases?

452


Explain conformed fact?

521


What is a real-time data warehouse? How is it different from near to real-time data warehouse?

547


What is application.cfm?

574