-----------Types of Fact Tables?




Answers were Sorted based on User's Feedback



-----------Types of Fact Tables?..

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

-----------Types of Fact Tables?..

Answer / sharath.dwh

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

-----------Types of Fact Tables?..

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




-----------Types of Fact Tables?..

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

-----------Types of Fact Tables?..

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

-----------Types of Fact Tables?..

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

Post New Answer



More Cognos Interview Questions

using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 Answers  


what is the difference b/w mdx and sql?

4 Answers   IBM, Cap Gemini,


5. Which type of report you build more, list, crosstab or chart and why?

0 Answers   IBM,


Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.

3 Answers   iGate,


How do we convert from Numeric to be Words?

0 Answers  






How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

0 Answers   HCL,


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

0 Answers  


How can we do the unit testing?

3 Answers   Logica CMG,


What is Cognos Powerhouse and what is it used for?

2 Answers   IBM, M Care,


What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?

2 Answers   TCS, HCL,


Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin

7 Answers   IBM,


---------------Tell me about DWH Concepts?

0 Answers   Bank Of America,






Categories