what is fact and what types of fact tables is there

Question Posted / ahalya inturi

4 Answers
9671 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is fact and what types of fact tables is there..

Fact:
Fact represents business measure.
Fact table:
A fact table is the primary table in a dimensional model where the numerical performance measurements of the are stored.

Is This Answer Correct ?

6 Yes

0 No

what is fact and what types of fact tables is there..

Answer / pawan

Fact: It is an object that is being analyzed.

Fact table: It consists of a composite key and facts, where ever attribute of the composite key is a foreign key to the dimension table or summarized information.

Two Types Of Fact Tables:
1) Cumulative Fact Table: Describes what was happened over the period of time. They contain addition facts.
2) Snap shot Fact Table: Deals with the particular period time. They contain non-additive and semi-additive facts.

Is This Answer Correct ?

3 Yes

0 No

what is fact and what types of fact tables is there..

Answer / chandrasekar

A Fact table contains unique combination of dimensional keys.
Fact tables are normalized.
A Fact tables have the facts at the lowest level of granularity.

Types of Fact table:
There are 3 types .
1)Detailed Fact table
2)Aggregate/Summarize fact table
3)Factless fact table

If it wrong means please send the correct answer to me
chandranmca2007@gmail.com

Is This Answer Correct ?

1 Yes

0 No

what is fact and what types of fact tables is there..

Answer / mural

i need example plz explain

Is This Answer Correct ?

0 Yes

0 No

Post New Answer