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 factless fact schema?

2 Answers  

After the complete generation of a report who will test the report and who will analyze it?

0 Answers  

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

0 Answers  

Explain what are the methodologies of data warehousing?

0 Answers  

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

0 Answers  

Explain what are the tasks that loadmanger process will do?

0 Answers  

What are fundamental stages of data warehousing?

0 Answers  

Why facts table is useful in representing the data?

0 Answers  

Where the data cube technology is used?

0 Answers  

What Oracle tools can be used to design and build a W/H?

1 Answers  

Explain me what are conformed dimensions?

0 Answers  

What are the possible data marts in retail sales?

0 Answers  

For more Data Warehouse General Interview Questions Click Here
Categories