DWH architecture?
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 Aggregate tables?
Explain what are necessary tasks to install reportnet software?
what is the difference between aggregate table and fact table ? how do you load these two tables ?
What are the possible data marts in retail sales?
What is the difference between aggregate table and materialized view?
What is query panel?
Whether dimension table can have numeric value?
What is a fact, dimension, measure?
Explain what is real time data-warehousing?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is the main difference between schema in rdbms and schemas in datawarehouse?
How do you setup Lo-cockpit?