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
Harikishan
Messages: 12
Registered: August 2003
Junior Member
Hi
I am an oracle professional and new to Datawarehouse. whats Fact Table,Dimension Table and whats cube? when each one is used? Thx.
Hari
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: Thu Mar 28 04:07:33 CDT 2024