cyberdiptikanta

 Profile Answers by cyberdiptikanta 

• Jul 20th, 2010

 

Fact table is bigger in size as compared to Dimension table.

Regards
Diptikanta

ypinky

 Profile Answers by ypinky 

• Jul 26th, 2010

 

Fact table can stores large amount of the numerical data.so,fact table is big in size.

yuvaevergreen

 Profile Answers by yuvaevergreen 

• Sep 1st, 2010

 

A fact table captures the data that measures the organization's business operations. A fact table might contain business sales events such as cash register transactions or the contributions and expenditures of a nonprofit organization. Fact tables usually contain large numbers of rows, sometimes in the hundreds of millions of records when they contain one or more years of history for a large organization.

Dimension tables contain attributes that describe fact records in the fact table. Some of these attributes provide descriptive information; others are used to specify how fact table data should be summarized to provide useful information to the analyst.

Faizal

• Aug 30th, 2011

 

Dimension Tables: These table are otherwise known as lookup tables which remain static with the business measures,dimensions, they do not change values when running ETL every time.

Fact Tables: This table captures data from the active transaction OLTP system and gets updated with rows each time you run a ETL.

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

goeljessica

 Profile Answers 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.