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 |
where do we see the run time of the report ?
What is difference between data mart and data warehouse?
if there are list,crosstab,chart how can you apply a single filter to all object?
What is Normalization?
What DB View and Bus View?
-------------What is Coditional Prompting?
Can u solve a small query on table the problem is whether it is possible to add extra cells for already existed table i.e if table contains 3 rows n 4 cols (3*4) it is possible to add another cell (4*4)
Define metrics studio?
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps
How do you Parametermap variables in Quiries?
write a query to display to 10 max record from the employee table?