-----------Types of Fact Tables?
Answer Posted / 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 View All Answers
What are the different types of reports present in cognos?
where you can save the report net documentation in our local system?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
What do you understand by ‘ibm predictive maintenance and quality’?
What is main difference mapplets and mapping?
Can you define a catalog and types of catalogs in cognos?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
what are the dimensions that you have in your current project?list them?
How do you Parametermap variables in Quiries?
what are slowly changing dimensions? Why we are used scd?
How to test a cube?
What is the use of powerplay web viewer in cognos?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What is the complex report you faced in real time?