Answer Posted / praveen
For performance tuning
1)it is done with the help of VLDB properties
2)check the intermediate sql passes and try to reduce the passes
3)apply filter conditions where ever required.
4)No cross join to be happened
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Name different type of objects in microstrategy?
Define different types of attributes in microstrategy desktop?
Can you explain surrogate key?
What is fact extension?
what are logical views used for?
Compare dataset and fileset?
Explain access control?
differentiate between two-tier, three-tier and four-tier connections.
What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?
Does microstrategy web support clustering via cisco local router or any other third-party clustering software?
Explain system call error?
Compare microstrategy and tableau.
What are attribute roles?
Can you create an event based schedule in microstrategy? How?
Can I access intelligent cubes without olap services?