-----------Types of Fact Tables?
- 6 Answers
- 20030 Views
- Bank Of America, CTS, I also Faced
- E-Mail Answers
Answer Posted / abd hfz
There are two types of Fact Tables namely :
1) Cummulative Fact Table : Facts collected over a period
of time are called CFT. This contains mainly Additive facts.
2) Snapshot Fact Table: Facts collected at the particular
time are called SFT. This are mainly Semi/Non Additive facts.
Also,
Fact less fact table : which has only FK and does not
contain any measures. eg: Visitors to the office
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is catalog and types of catalogs in cagnos and which is better?
-----------Diff b/w OLAP and RDBMS?
Diff b/w Crossproduct and Outerjoin?
write a query to display the departments with no employee?
What is the enterprise class platform architecture of cognos 8?
What is the difference between Open Connection command ang Open Session Command?
Can you define a datastore in cognos?
Give me any example of semi and non additive measures?
What are query items?
What errors and types of errors you faced in Cognos ReportNet?
What are shortcuts? Where it can be used? What are the advantages?
What is a Folder?
What is difference between data mart and data warehouse?
How to generate cubes in cognos?
What are the different kinds of panes included in cognos?
