Home » Developer & Programmer » Data Integration » whats Fact Table,Dimension Table Cubes
whats Fact Table,Dimension Table Cubes [message #93275] Mon, 12 April 2004 20:17 Go to next message
Messages: 12
Registered: August 2003
Junior Member
I am an oracle professional and new to Datawarehouse. whats Fact Table,Dimension Table and whats cube? when each one is used? Thx.
Re: whats Fact Table,Dimension Table Cubes [message #93287 is a reply to message #93275] Thu, 20 May 2004 03:43 Go to previous message
Suresh Raja
Messages: 4
Registered: February 2003
Junior Member
Dear Hari,

A FACT table is nothing but a transaction table in a typical OLTP system with de-normalized fashion.

A Dimension Table is the one which we will call as Master / Header tables in the OLTP systems.

Cube are formed by dimensions, which identifies how the data is organized or the measures being tracked. One element of each dimension identifies the location of a cell in a cube.
(measures are nothing but the business facts - like price, quantity etc..)
Previous Topic: ORA-01858-error when running package
Next Topic: Actuate with JDBC
Goto Forum:

Current Time: Mon Mar 27 05:24:02 CDT 2023