how many facts&dimensions tables in project? it's very
urgent.........
- 2 Answers
- 5375 Views
- I also Faced
- E-Mail Answers
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 |
Tell me about Schemas?
Can you define set to be cardinality?
What are the advantages of cognos?
what are the enhancements in cognos reportnet ?
-------------------What is Deployment?
What is the use of 'individual data source' option while using filter in query studio?
What is Tool Tip? and how to create in report studio?
What is difference between content store and content manager?
what is the difference between cognos8 fm and cognos reportnet fm?
how to get the all values from a prompt using 'ALL' use and display value in prompt
4. How many dimensions did you use in your reports?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Teradata 
