1.In middle level project aprox How many Number of Dimension and Facts are exists?2.In a complex report how much maxm. No. of dimension are exist in a Cube?

Interview Candidate
Jan 2nd, 2007
2
2791

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

ranga

Jan 3rd, 2007

Actually there is no limitations for no.of dim&fat tabels for project. approximately 40+ dim tables, 5+ fact tables.
ranga
ranganadhn@yahoo.com

thakkalapelly anil

Aug 30th, 2007

Actually there is no limitations for fact and dimensions tables. That depends upon the data and the project. Normally we have 60 dimensions and 17 fact tables.