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

wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.

1 Answers  

Why denormalization is promoted in universe designing?

0 Answers  

Explain what is the advantages data mining over traditional approaches?

0 Answers  

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

4 Answers   IBM, MAHINDRA, Tech Mahindra,

what are the major three types of modeling used?

0 Answers   InfoAxon Technologies,

How to get the first 100 rows from the flat file into the target?

0 Answers  

What is critical column?

0 Answers  

Explain what is the difference between a primary and secondary actor in use case modeling?

0 Answers  

Explain the hierarchies level data warehousing.

0 Answers  

Explain what is power center repository?

0 Answers  

Explain degenerate dimension table?

0 Answers  

In a star schema, are foreign key constraints between facts and dimensions neccessary?

0 Answers  

For more Data Warehouse General Interview Questions Click Here
Categories