-----------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

------------------- What is Busschema?

1 Answers   Cap Gemini,


How many types of models are present in cognos.?

4 Answers  


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.

0 Answers   HCL,


How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.

5 Answers   HSBC,


WHAT ARE THE DISTNICT VARIABLES?

0 Answers  






What is the diff between Drill through reports and Master detail reports?

2 Answers   CSC, TCS,


How to create a Ratio in Cognos Report studio Reports?

1 Answers   IBM,


how many types of variables in cognos report net and cognos 8

4 Answers   HCL, Merrill Lynch,


how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

0 Answers   HCL,


Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance

0 Answers   IBM,


What is content Manager?

3 Answers   HCL, Kekran Mekran,


how to merge 2 crosstabs thans

0 Answers   HCL,






Categories