Data Warehouses MicroStrategy Interview Question:

In Microstrategy, how can we direct the sql generated to use a specifc table?

I know of using ApplySimple, but there are other ways too?

Submitted by: Administrator

If you need to use a specific table , we need to play with the logical size of that table. Whenever MSTR frames a query it retrieves data from the table that has the least logical size and hence when you set the logical size of your table to be least compared to the other base table, MSTR will retrieve data from this specified table.
Submitted by: Administrator

we can create a separate table with specific columns we need to use(i.e .a more appropriate table using table alias)
Submitted by: Anasuya