| datawarehouse structure [message #127509] |
Tue, 12 July 2005 00:19  |
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  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
