Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 you link a query to a data container manually in Report Studio?

0 Answers  


How to test a cube?

0 Answers  


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

2 Answers  


What snowflake and Starschema?

2 Answers   HCL,


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

0 Answers  


how can you get the errors in job? when loops are araised we get error?

0 Answers   Syntel,


16. How can we create top 10 and bottom 10 records in the same list?

9 Answers   TCS,


Mention the difference between ‘macros’ and ‘prompt’?

0 Answers  


2.How do you drill through report from Report Studio to Analysis studio?

3 Answers   IBM,


what is Associated grouping? and how it works in cognos impromptu?

1 Answers   IBM,


Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers   DELL,


What is meant by Reportstudio shortcut?

0 Answers  


Categories