-----------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
Can you define slice?
Can you define confirmed dimension?
Can you define framework manager?
what are the errors faced while bursting the reports and how to solve those errors?
-----------------What is Direct and Conventional loading?
What is the difference between low affinity and high affinity connections?
How to test a cube?
how u will determine the performence tune will occur either in report or system
What is a dimension?
How create measures and demensions?
What is the model filter?
what is model and say about process how to create model and how to test model?
What are the batches and it’s details?
how to test reports in cognos?
What are the different kinds of panes included in cognos?