Interested to Buy Any Domain ? << Click Here >> for more details...
-----------Types of Fact Tables?
- 6 Answers
- 22072 Views
- Bank Of America, CTS, I also Faced
- E-Mail Answers
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 anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is cognos connection?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What errors and types of errors you faced in Cognos ReportNet?
What is the information present in the cognos configuration file?
--------------Diff b/w ODS and OLAP?
How to apply securities for reports in cognos connection?
What you mean by drill across?
Write some methods to apply securities in framework manager model?
What do you mean by drill through report?
What do you understand by user class in cognos?
Define metrics studio?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
how to test reports in cognos?
What are the types of catalogs in cognos?
