What is difference between Union and Union All ?
Answer / sagar
1) By union ALL u will get duplicate records also(the records common between 2 tables 2 times) but Union gives u union of 2 tables
2) 'Union All' is faster than Union
| Is This Answer Correct ? | 0 Yes | 0 No |
Is that possible to Insert and Update a record in the Database through Microstrategy..?
Difference between project merge and object manager?
A report is taking few seconds to run.The same report is taking very long time on the next day without doing any kind of changes in the report. What could be the reason? how do you tune the report.
What are configuration objects?
What is scanmd and md doctor?
What do you mean by derived metrics?
Write the components microstrategy metadata?
How is security handled?
If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?
Explain confirmed dimensions. When are they used?
Explain fact relation?
What happens if the owner of an object does not exist in the destination project?