DWH architecture?

Answer Posted / sandeep.t nizamabad

THE ARCHITECTURE CONTAINS THE FOLLOWING COMPONENTS
1.OLTP SYSTEMS
2.STAGING LAYER
3 DATA WAREHOUSE
4.DATA MARTS
5.REPORTS
6.BUSINESS USERS

Is This Answer Correct ?    11 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

1822


What is the difference between view materialized view and view?

598


What is data warehosuing hierarchy?

589


How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

567


What is load manager?

571






I need a good brd and uc template?

593


How to pivot row data using informatica?

528


Can we have multiple application.cfm file in an application?

493


Difference between cold fusion 5 and cold fusion mx 6?

593


What are diagrams?

623


Explain what is batch and describe about types of batches?

616


What is the difference between aggregate table and materialized view?

608


Explain difference between data ware house & data mart?

526


Why null values are mapped as 0 in fact tables?

540


Explain what is the limit to the number of sources and targets you can have in a mapping?

555