-----------Types of Fact Tables?
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
Explain is there any comparison available for cognos reportnet vs crystal reports?
What are all the components of Report Studio?
WHAT ARE THE DISTNICT VARIABLES?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Write various indexes used in cognos?
What is meant by Reportstudio shortcut?
Can you define cognos impromptu?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
Give me any example of semi and non additive measures?
How do we convert from Numeric to be Words?
What is defined as Query studio?
hi my name is siraj i want to know cognos queriy language
can you tell me what are the dimension tables are used in project
What is cognos powerhouse?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.