Interested to Buy Any Domain ? << Click Here >> for more details...
DWH architecture?
- 6 Answers
- 18718 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 difference between model & package?
Define data warehouse?
What is the main difference between inmon and kimball philosophies of data warehousing?
What is the limit to the number of sources and targets you can have in a mapping?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What is staging area?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What is factless fact tables?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
what is parallel query?
Explain how to get the first 100 rows from the flat file into the target?
Teradata 
