Answer / sandeep.t nizamabad

THE ARCHITECTURE CONTAINS THE FOLLOWING COMPONENTS
1.OLTP SYSTEMS
2.STAGING LAYER
3 DATA WAREHOUSE
4.DATA MARTS
5.REPORTS
6.BUSINESS USERS

Answer / ajay kumar

it is composed of dataware house
layer,datastagelayer,process management layer,meta data
layer,application layer and other etc

Answer / rb

From Data perspective these 4 layers can be seen in DWH
architecture :

Staging
Atomic or Base layer,
Aggregate layer,
Presentation layer

Answer / kammari.krishnaiah

1.Source
2.Staging Area
3.Data Warehouse
4.Data mart

Answer / sowmi

DWH Architecture:

It has 3 layers:

1.Staging
2.Integration
3.Target

In staging we get the raw data.In integration we process i.e
we cleanse the data.In target the data is ready to be used
by end users for report generation.

Answer / sandeep.t nizamabad

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

What is a cube in data warehousing concept?

0 Answers  

Explain what are necessary tasks to install reportnet software?

0 Answers  

How can we run the graph?

0 Answers  

What are the advantages of raid 1, 1/0, and

0 Answers  

What are the mapping paramaters and maping variables?

0 Answers  

Why is dimensional normalization not required?

0 Answers  

What is difference between Mapplet and reusable transformation?

3 Answers   UST,

explain about balanced dimension,

0 Answers  

Define data warehouse?

0 Answers  

What is MDX?

2 Answers   TCS,

What is the difference between a data warehouse and a data mart?

15 Answers   Apex, ASD Lab, Bank Of America,

Explain what are the modules in power mart?

0 Answers