Interested to Buy Any Domain ? << Click Here >> for more details...
-----------Types of Fact Tables?
- 6 Answers
- 22083 Views
- Bank Of America, CTS, I also Faced
- E-Mail Answers
Answer Posted / maya
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 ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the types of catalogs in cognos?
What is cognos powerhouse?
Write some methods to apply securities in framework manager model?
how u will determine the performence tune will occur either in report or system
what is online view?
Explain the difference between powerplay transformer and power play reports?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What are the other methods working as deployment functionality?
Define report item?
What you mean by drill across?
Can you define confirmed dimension?
Cleared COG-112 with 100% score today. What next certification should i go for?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
Can you define snapshot?
What is cognos reporting tool?
