-----------Types of Fact Tables?
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 |
i have a table with 3 columns country,empname,salary and i want the query for get the name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance
where exactly determinants are used in cognos framework manager?
How can we find out cardinality between two tables?
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
-----------Types of Fact Tables?
6 Answers Bank Of America, CTS,
What is the difference between macro & Parameter
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?
Interval Prompt's Usage? Example for usage in Project
What is the function of cognos dispatcher?
Can you define metrics designer?
What is the use of Generated Prompt? Where is it used in realtime project?