-----------Types of Fact Tables?

Answer Posted / vishwamithra

THERE ARE 3 TYPES OF FACTS
1)ADDTIVE:FACTS THAT CAN BE SUMMED

2)SEMI ADDITIVE:FACTS THAT CAN BE SUMMED UP FOR SOME OF THE
DIMENSIONS AND NOT OTHERS.
EX:BANK BALANCE
3)NON ADDITIVE:CAN'T BE SUMMED.
EX:RATIO,AVG,VARIANCE
------------------------------------------------------------
----------There are two types of Fact Tables namely :

1) Cummulative Fact Table : Facts collected over a period
of time are called CFT.

2) Snapshot Fact Table: Facts collected at adhoc basis are
called SFT.
-----------

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1572


Why need staging area database for dwh?

612


Name the types of report?

533


What is defined as catalog and types of catalogs in Cognos?

547


What is cognos reporting tool?

590






What is the function of model design accelerator?

510


I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1509


Explain informatica architecture?

529


what are the dimensions that you have in your current project?list them?

1614


How can create users and permissions in cognos?

544


What are all the components of Report Studio?

626


What is drill down and slicing and dicing whats the difference between them?

525


What are all the types of report?

550


-------------How you design DWH?

1870


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

1849