Interested to Buy Any Domain ? << Click Here >> for more details...
DWH architecture?
- 6 Answers
- 18638 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 is hash partition?
What is data warehouse architecture?
Explain what are conformed dimensions?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
How can Oracle Materialized Views be used to speed up data warehouse queries?
What are the fundamental elements of the data warehouse?
What is Grain & Granularity in Data Warehouse.
How can you define a transformation? What are different types of transformations in Informatica?
What is power play plug in?
What Oracle features can be used to optimize my Warehouse system?
What are the different types of fact tables used in data warehousing?
What is partitioning? What are the types of partitioning?
Teradata 
