Answer Posted / 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.

Explain fact?

974

---

While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

925

---

What are vldb properties?

1021

---

What do you mean by derived metrics?

996

---

What is a conditional attribute in microstrategy?

1100

---

Is there a difference between view filter and report filter?

920

---

How do you ensure simultaneous releases across multiple operating systems?

970

---

What is smart metric?

968

---

Explain four-tier connection?

934

---

You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

931

---

you are required to disable webusers to use only one i-server. How would you do that?

892

---

Is olap services sold as a separate product?

921

---

Your application mode has crashed. How would you run your i-server?

982

---

What is non-aggregate metric?

1016

---

Explain static reports?

1006

---