how many facts&dimensions tables in project? it's very
urgent.........

Answers were Sorted based on User's Feedback



how many facts&dimensions tables in project? it's very urgent...........

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

how many facts&dimensions tables in project? it's very urgent...........

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

Post New Answer

More Cognos Interview Questions

How can we Maintain the Cube Security by Category level and Dimension level ?

0 Answers  


How do you test the reports? Explain the Unit testing procedures after developing the reports?

1 Answers   HP, TCS,


What is difference between page break and section report?

0 Answers  


whats the difference between previous version of cognos and cognos 8 BI?

1 Answers   IBM,


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

0 Answers  






What is metric store database?

0 Answers  


what is crosstab space

1 Answers   IBM,


what is an associated query?

2 Answers  


what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly

2 Answers   TCS,


how can you set the image in the report

1 Answers   HSBC,


How to create users and permissions in cognos?

4 Answers   IBM,


How do I remove the hyperlink from the drill through report?

2 Answers   Misys,


Categories