-----------Types of Fact Tables?
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 do you mean by query studio?
What is the difference between Standard and Metrics folder?
How the Bursting happens in same report and how to Print the bursting Report?
What r the names of the reports that you prepared?
what is catalog and types of catalogs in cagnos and which is better?
What are the different kinds of panes included in cognos?
What is model?
How Metrics Studio is better than Report Studio?
What is Fullouterjoin?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
When we save a report in report studio with what extn it save?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What are the components used in web tier?