what is subqueary and what is temporary tables?
Answers were Sorted based on User's Feedback
Answer / praveen
A Subquery or Inner query or Nested query is a query within
another SQL query and embedded within the WHERE clause.
A subquery is used to return data that will be used in the
main query as a condition to further restrict the data to
be retrieved.
Temparory tables are used in creation of storing data for a
while and this table is used in another sql .
That means the result of temp table will be used in another
sql up on which the resultant data is to be displayed.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sunny
A query with another query is called sub query and temporary tables are used in creation of storing data for a while and tis tabel is used in another sql.
Is This Answer Correct ? | 0 Yes | 0 No |
What are the tracing options available in microstrategy object manager?
Explain fact degradation?
Can you create an event based schedule in microstrategy? How?
What are the different types of metrics available in microstrategy?
Explain the difference between rolap and molap?
Compare dataset and fileset?
What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?
what specific features and functionality do you get with olap services?
How do you ensure simultaneous releases across multiple operating systems?
What formatting can be applied to the information that is sent out by microstrategy narrowcast server?
Imagine this, you are required to reset the password for all users at a time. How would you do that?
How conflicts occur and what are the ways to resolve them?