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

Explain the importance of data warehouse?

0 Answers  

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

0 Answers  

What is the advantages data mining over traditional approaches?

0 Answers  

Give some difference between oltp and olap.

0 Answers  

Explain what are fact, dimension, and measure?

0 Answers  

How can you define a transformation? What are different types of transformations in Informatica?

7 Answers   TCS,

What is a functional dependency f said to be minimal?

0 Answers  

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

0 Answers  

What are the data types present in bo?

0 Answers  

difference between For each and for all

2 Answers  

What is the difference between er modeling and dimensional modeling?

0 Answers  

what are the all possible features supported modify stage?

0 Answers  

For more Data Warehouse General Interview Questions Click Here
Categories