Which table is large terms of size, fact table or dimension table? Explain

goeljessica

 Profile Answers by goeljessica Questions by goeljessica

• Sep 7th, 2012

Fact tables: Have any measurable value in it and it contain foreign key of all the dimension table.

Dimension Tables: Do not have any numeric value, and it shows the characteristics that describe a transaction.

santhosh

• May 28th, 2012

Dimension:It gives description about fact.

Fact:Is knows as Key Identifier(Measures)

EX:
Empno Empname Sal Deptno
1 A 20,000 201
2 B 15,000 203

All facts are numeric

Answer Question  Select Best Answer