How many fact tables and dimension tables in your project?
Answers were Sorted based on User's Feedback
Answer / c h i t t i
Depend on project, for ex. mostly fact tables 1 or 2 and
dimensional tables infinity.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / nasa
In my project fact tables are 5 and dimension tables are 36
and team size is 12 and duration is 16 month and i developed nearly 80 to 990 reports in my project and my client is australia....
| Is This Answer Correct ? | 3 Yes | 0 No |
How applying "Level Span" in Cognos 8.3?
What is Performance Tunning Test?
what r the names of the reports that u prepared???
9 Answers Covansys, IBM, Wipro,
what is field set? what is the query calculation and layout calculation?
What is zero-foot print?
Explain the Difference Between Bursting and Scheduling?
does query is created for date prompt?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
3 Answers TCS, Thomson Reuters,
what is the difference between native sql and cognos sql?
How we check the errors before running the report?
how can we improve performance of the reports?
-------------How you design DWH?