Interested to Buy Any Domain ? << Click Here >> for more details...
DWH architecture?
- 6 Answers
- 18736 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
it is composed of dataware house
layer,datastagelayer,process management layer,meta data
layer,application layer and other etc
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / 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 |
Answer / kammari.krishnaiah
1.Source
2.Staging Area
3.Data Warehouse
4.Data mart
| Is This Answer Correct ? | 1 Yes | 0 No |
OLTP SYSTEMES CONTAINS
1.FLAT FILES
2.DBASE
3.ORACLE
4.SAP
WE WILL EXTRACT THE DATA FROM OLTP TO STAGING LAYER
AND CONVERT THE DATA FROM INCONSISTENT TO CONSISTENT FORM
BEFORE LOADING TO DWH.
DWH IS NOTHING BUT OLAP SYSTEMS
IT CONTAINS DEPTS. LIKE FINANCE,SALES,PURCHASE,H.R
DATA MARTS ARE SUBSETS OF AWHWHICH ARE USED TO SATISFY THE
REPORTING REQUIREMENTS OF A DEPTS
Eg: SALES , FINANCE,PURCHASE,HR
| Is This Answer Correct ? | 3 Yes | 4 No |
What are the various tools? Explain name a few?
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
Where the applications and where ware house management system is used?
What is latest version of power center / power mart?
Explain what are the tasks that loadmanger process will do?
Is there any default username & pwd for bo designer & supervisor?
What is difference between e-r modeling and dimensional modeling?
What are data modeling and data mining?
Explain what is the difference between view filter and report filter?
OLAP architecture?
What is the capacity of power cube?
How to create different types of templates?
Teradata 
