-----------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
What is a Query Subject?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
How can you link a query to a data container manually in Report Studio?
What is model?
Can you define cognos impromptu?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
Can you define a query subject?
which type of project we r going to snowflake schema
What is Bitmap Index?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
How do you improve the performance of the Cognos Analytics report
What do you understand by ‘ibm predictive maintenance and quality’?
Can you explain cognos planning?
What is the difference between a cascading report and drill through the report?
Can you define metrics designer?