DWH architecture?
- 6 Answers
- 16095 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 |
Explain the versions of reportnet?
What are different deliverables according to phases?
What is the difference between view materialized view and view?
Store (and count) non-fact records?
What are partition points?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
How to create prompts in report net?
How can we load the time dimension?
What are templates in which way it is help full?
Do you view contain data?
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do
What is fact less fact table? Where you have used it in your project?
Teradata 
