sunil

• May 13th, 2005

 

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 .

Harsha

• Aug 17th, 2005

 

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 

shahid khan

• May 12th, 2006

 

What is a three tier data warehouse?

nigampradhan

• Oct 15th, 2006

 

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.

shayona

 Profile Answers by shayona 

• Jun 1st, 2009

 

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.

butair

 Profile Answers by butair 

• Aug 3rd, 2009

 

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