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

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

0 Answers  

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

0 Answers  

Explain what are the basic needs to join two sources in a source qualifier?

0 Answers  

What is the difference between ods and oltp?

0 Answers  

Explain differences between star and snowflake schemas?

0 Answers  

What are diagrams?

0 Answers   InfoAxon Technologies,

How do you create surrogate key using ab initio?

0 Answers  

What is a star schema? Why does one design this way?

3 Answers  

How to pivot data using informatica when you have variable amount of pivot rows?

0 Answers  

What is type 2 version dimension?

0 Answers  

Define Data Warehousing?

0 Answers   Wipro,

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

0 Answers  

For more Data Warehouse General Interview Questions Click Here
Categories