Interested to Buy Any Domain ? << Click Here >> for more details...
-----------Types of Fact Tables?
- 6 Answers
- 21792 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
Can you define a catalog and types of catalogs in cognos?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What are the different types of reports present in cognos?
What is the difference between Standard and Metrics folder?
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.
WHAT ARE THE DISTNICT VARIABLES?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
What is the report studio?
What is the use of cognos decision stream?
What is Additive function?
What is main advantage datawarehousing over oracle?
What are the types of folder present in cognos?
Explain the different types of views used in cognos.
What are the types of security?
how to perform single sign in cognos by using url?
