InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is A Logical Size Of A Table And What Does It Depend On? |
|
Answer» Logical size is Microstrategy way of generating the best suitable/optimized SQL to fetch the REQUIRED DATA. Microstrategy follows an algorithm to calculate the logical size of a table, which depends on the no of attributes and facts based on the table and also the POSITION of those attributes in the system hierarchy. The logical size does not depend on the actual data (no of ROWS) in the database. If the candidate answers this than his concept is wrong Logical size is Microstrategy way of generating the best suitable/optimized SQL to fetch the required data. Microstrategy follows an algorithm to calculate the logical size of a table, which depends on the no of attributes and facts based on the table and also the position of those attributes in the system hierarchy. The logical size does not depend on the actual data (no of rows) in the database. If the candidate answers this than his concept is wrong |
|