Bala

• Jul 21st, 2006

 

I know some, there are Additive Facts,Semi-Additive, Non-Additive, Accumulating Facts,Factless facts,Periodic fact table, Transaction Fact table.

Thanks
Bala

Sobha

• Jul 21st, 2006

 

There are
Factless Facts:Facts without any measures.
Additive Facts:Fact data that can be additive/aggregative.
Non-Additive facts: Facts that are result of non-additon
Semi-Additive Facts: Only few colums data can be added.
Periodic Facts: That stores only one row per transaction that happend over a period of time.
Accumulating Fact: stores row for entire lifetime of event.

There must be some more, if some one knows pls add.

calltomadhu

 Profile Answers by calltomadhu 

• Sep 23rd, 2006

 

hi

there are 3 types

additive

semi additive

non additive

thanks

madhu

shiva

• Oct 30th, 2006

 

hai

there r three types of facts

Additive Fact-Fact which is used across all dimensions

semi Additive Fact- Fact which is used some dimesion and not with some

Non Additive Fact- Fact which is not used any of the dimesion

senthilkar

 Profile Answers by senthilkar 

• Jan 22nd, 2008

 

1. Regular Fact - With numeric values
2.Factless Fact - Without numeric values