-----------Types of Fact Tables?
- 6 Answers
- 19968 Views
- Bank Of America, CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tanveer ahmed
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 ? | 30 Yes | 7 No |
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
| Is This Answer Correct ? | 28 Yes | 8 No |
Answer / vishwamithra
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 ? | 12 Yes | 3 No |
Answer / 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 |
Answer / 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 |
Answer / suresh
Fact tables have 4 types:
1)Additive Fact table
which can be summed ex:Sales,we can summed sales amount
2)Non-Additive fact table
which can not be summed ex:
3)Semi Additive fact table
That can be summed up for some of the
dimensions and not others.
EX:
4)Fact less fact table:which does not contain measures.
ex:student :faculty,year,course details..there is no measures
| Is This Answer Correct ? | 8 Yes | 8 No |
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
What is Merging, Segments and porting in Framwork Manager?
Mention the difference between ‘macros’ and ‘prompt’?
What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?
How to create multilingual reorts?
what is tabular set? how can you break the report?
What do you understand by the term 'model durability'?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What is snapshot ?
Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?
Can you define report item?
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.
Teradata 
