Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category

DWH architecture?

Question Posted / guest

Answers were Sorted based on User's Feedback



DWH architecture?..

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

Is This Answer Correct ?    11 Yes 3 No

DWH architecture?..

Answer / ajay kumar

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

DWH architecture?..

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

DWH architecture?..

Answer / kammari.krishnaiah

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

Is This Answer Correct ?    1 Yes 0 No

DWH architecture?..

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.

Is This Answer Correct ?    0 Yes 0 No

DWH architecture?..

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

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More Data Warehouse General Interview Questions

what is the difference between aggregate table and fact table ? how do you load these two tables ?

12 Answers   Target,

What are the various file formats involved in reportnet?

0 Answers  

What is difference between a connected look up and unconnected look up?

1 Answers  

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

0 Answers  

How did you plan your Data ware house project?

0 Answers   TCS,

Explain what is ods (operation data source)?

0 Answers  

What is Molap and Rolap? What is Diff between Them?

10 Answers  

Explain what are the various reporting tools in the market?

0 Answers  

what role views play in dimensional modeling?

1 Answers   TCS, Zensar,

What are the data types present in bo? What happens if we implement view in the designer n report?

0 Answers  

How can you communicate with web server (apache or iis) from coldfusion?

0 Answers  

Explain what is the difference between datawarehouse and bi?

0 Answers  

For more Data Warehouse General Interview Questions Click Here
Categories