-----------Types of Fact Tables?
Answer Posted / 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 |
Post New Answer View All Answers
What are products of cognos?
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..
Define dimensions?
What is the difference between ‘macro’ and ‘prompt?
Define the slice and dice?
what are slowly changing dimensions? Why we are used scd?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
what is online view?
What are the different types of important services used in cognos?
4. How many dimensions did you use in your reports?
how can you get the errors in job? when loops are araised we get error?
What are the components used in web tier?
How Metrics Studio is better than Report Studio?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Please explain the different stages in creating a report in cognos report net?