-----------Types of Fact Tables?
- 6 Answers
- 19966 Views
- Bank Of America, CTS, I also Faced
- E-Mail Answers
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 User Securities?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
What are the types of folder present in cognos?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What is difference between page break and section report?
in u r data u having duplicates how to fetch the latest data in our report?
Can you explain dynamic query mode?
What is Metrics designer?
How to Reset Pagenumbers in one report.
What is cognos reporting tool?
how to test reports in cognos?
How is cognos model organization works?
What are the two types of framework manager?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
