What is difference between Union and Union All ?
Answer Posted / 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 |
Post New Answer View All Answers
Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.
Why does microstrategy object manager search for object dependencies?
Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?
What happens if the owner of an object does not exist in the destination project?
Explain fact structure?
What are the benefits of using microstrategy intelligence server?
What are configuration objects?
Explain the difference between holap and rolap?
Can we access multiple operational databases from within a single microstrategy project?
What is fact extension?
What is metadata in microstrategy?
Explain fact table?
How long does it take to get microstrategy desktop up and running?
Explain four-tier connection?
what is smart metrics in microstrategy?