Home » Developer & Programmer » Data Integration » datawarehouse structure
datawarehouse structure [message #127509] Tue, 12 July 2005 00:19 Go to next message
gautamvv
Messages: 254
Registered: June 2005
Senior Member
i could not find a satisfactory link in the net

from where i can get a good basic understanding of the

structure of a datawarehouse. (from oltp to olap).

can anyone suggest me a good book for dw?

and a good link where i can find out the structure of a dw?

i have doubts like 1) what is staging?

2) what is olap? is the data which is already stored in a

warehouse is called an olap?

3) should an etl consultant study the data after being

stored in the warehouse?

Re: datawarehouse structure [message #129665 is a reply to message #127509] Tue, 26 July 2005 03:59 Go to previous messageGo to next message
krsoujanya
Messages: 8
Registered: July 2005
Junior Member
Hai,
!) What is staging?A) A place where data is processed before entering the warehouse.


2) What is olap? Is the data which is already stored in a warehouse is called an olap?A) On Line Analytical Processing (OLAP)
OLAP functionality is characterized by dynamic, multidimensional analysis of historical data, which supports activities such as the following:
- Calculating across dimensions and through hierarchies
- Analyzing trends
- Drilling up and down through hierarchies
- Rotating to change the dimensional orientation
OLAP tools can run against a multidimensional database or interact directly with a relational database.

3) Should an ETL consultant study the data after being stored in the warehouse?
A) No, the ETL should study the data before storing it into the warehouse i.e. he extract data from the sources and transform the data according to user’s requirements then he loads data in to warehouse.
Re: datawarehouse structure [message #129941 is a reply to message #127509] Wed, 27 July 2005 06:47 Go to previous message
gautamvv
Messages: 254
Registered: June 2005
Senior Member
thanks a lot
Previous Topic: Datawarehousing in Teradata
Next Topic: Business objects - little crosstable problem
Goto Forum:
  


Current Time: Thu Mar 28 10:03:03 CDT 2024