ETL - What is a three tier data warehouse?

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 2 of 65

What is a three tier data warehouse?

Total Answers and Comments: 6

Last Update: August 03, 2009

Sponsored Links

Best Rated Answer

—

Submitted by: Harsha

The 3 tiers are:
1. Data tier - bottom tier - consists of the database
2. Application tier - middle tier - consists of the analytical server
3. Presentation tier - tier that interacts with the end-user

Above answer was rated as good by the following members:
butair

May 13, 2005 06:50:51

sunil

RE: What is a three tier data warehouse?

Three tier data warehouse contains three tier such as bottom tier middle tier and top tier.
Bottom tier deals with retrieving related datas or information from various information repositories by using SQL.
Middle tier contains two types of servers.
1.ROLAP server
2.MOLAP server
Top tier deals with presentation or visualization of the results .

Is this answer useful? Yes | No

August 17, 2005 19:21:29

Harsha

RE: What is a three tier data warehouse?

The 3 tiers are:
1. Data tier - bottom tier - consists of the database
2. Application tier - middle tier - consists of the analytical server
3. Presentation tier - tier that interacts with the end-user

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 12, 2006 05:43:47

shahid khan

RE: What is a three tier data warehouse?

What is a three tier data warehouse?

Is this answer useful? Yes | No

October 15, 2006 05:22:22

nigampradhan

RE: What is a three tier data warehouse?

a three tier DWH means top level middle level bottom level. it's right. but i think it 's combination of respectivetool's cliet respective tool's server & server manager.

Is this answer useful? Yes | No

June 01, 2009 06:44:55

shayona

Member Since: June 2009 Contribution: 1

RE: What is a three tier data warehouse?

Three tier data warehouse contains three layer. 1st layer does all the data extraction and 2nd layer does transformation and in 3rd layer there is loading of clear data.

Is this answer useful? Yes | No

August 03, 2009 12:33:12

butair

Member Since: February 2008 Contribution: 1

RE: What is a three tier data warehouse?

Client:-

* GUI/Presentation logic
* Query specification
* Data Analysis
* Report formatting
* Data access

Application/Data Mart Server:-

* Summarizing
* Filtering
* Meta Data
* Multidimensional view
* Data access

DW Server:-

* Data logic
* Data services
* Meta data
* File services

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank