what is dimension table?

dimesion is nothing but structure,it contains tables and

structure

a dimension table is one which contain master data

all the data in the fact is related to the data in the

dimension.

dimension table contain the detail information abt facts

e.g customer name ,custmer address etc

imensional Table:-It contains detailed information of one

Particular department

Eg:-Customer dimension it contains all the information

about the customer like name,place,DOB, city n so on along

with one primary key.

dimension tables contains described data

dimetion table is havig decriptive data about u r

bissiness, it having more no row

a dimension table contains the master data pertaining to a

subject area. this table is referenced by the fact table

when it is loaded.

DIMENSION TABLE CONTAINS DISTRIBUTTED DATA OR MASTER

DATA,WHICH WE CAN ANALYZE DEPENDING ON FFACTS OR MEASURES

IN FACT TABLE.

Table which contains important business entities called

Dimension Table.

Dimension Tables are also called as Lookup or Reference

Table