Interested to Buy Any Domain ? << Click Here >> for more details...
-----------Types of Fact Tables?
- 6 Answers
- 22031 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
Can you define snapshot?
What is difference between content store and content manager?
How security is concerned with Reportnet? Explain its implementing steps.
What are the components of report net?
What are all the types of report?
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.
how u will determine the performence tune will occur either in report or system
5. Which type of report you build more, list, crosstab or chart and why?
How is cognos model organization works?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
--------------Explain Table of contents?
What do you understand by the term 'model durability'?
What are the different types of important services used in cognos?
What is catalog and types of catalogs in cagonos and which is better?
Why cognos decision stream is used?
