how many facts&dimensions tables in project? it's very
urgent.........
Answers were Sorted based on User's Feedback
Answer / mow
Depending on the project it varies...
in general 3 - 4 facts and 15 - 20 dimensions can be there
in a medium scale project
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / palzkumar
NOT more than 16 Dimension.
cuz a Fact table can have maximum 16 foreign key only.
-palz-
Is This Answer Correct ? | 0 Yes | 1 No |
-------------------What is StarShema?
What is called Cognos powerplay?
The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.
what is an associated query?
What are various types of gateways in cognos?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
16. How can we create top 10 and bottom 10 records in the same list?
3. What was the size of your cube?
what is dimention?explain dimentable with example?
What is the use of powerplay web viewer in cognos?
What is the importance of Dimension in the cognos.