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

Fact Table is a) Completely Normalized b) Partially Normalized c) Completely De-normalized d) Partially De-normalized

Vidhan

• Feb 23rd, 2018

A.) Completely Normalized

OM PRAKASH JHA

 Profile Answers by OM PRAKASH JHA Questions by OM PRAKASH JHA

• Sep 7th, 2010

Fact table cntains factual data as well as composite key value with regard to all dimentional table.

Answer Question  Select Best Answer

ypinky

 Profile Answers by ypinky Questions by ypinky

• Jul 26th, 2010

SCD-1 (Current)Overwriting the old values in the dimension record. SCD-2 (History and Current)Creating an additional dimension record at the time of the change with the new attribute values. ...

desaial

 Profile Answers by desaial Questions by desaial

• Dec 9th, 2008

SCD means Slowly Changing Dimension. The price of the product, address of the person, name of the city are few examples of SCD.There are three methods to capture SCD.Type 1: Overwriting the old values...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Praveen

• Aug 15th, 2005

---

# Additive: Additive facts are facts that can be summed up through all of the dimensions in the fact table. 
# Semi-Additive: Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others. 
# Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.

cognos_anu

• Jun 20th, 2017

The facts which cannot be summed up across any dimension.
for e.g. Percentage, temperature

Srikant

• Nov 20th, 2016

Please give me a fact table where I cannot add the percentage. Especially if the percentage is calculated for that particular fact table. Are we saying that percentages stored in the fact table might ...

Improve Answer