WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ?
Thanks In advance Prakash
Answer Posted / interested
In general the same index theory applies to DW as it is for
any RDBMS. So we can have one clustered index and several
non-clustered indexes on a table. defininng the index
depends on the need for the particular SQL. We usually
define them on the columns used in the join clause and in
the where clause to fecilitate the faster fetch.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Can Bo generates the Report from the cubical data Explain?
How many universes can be created in a project?
Can more than 1 metric be applied on an analytic in business objects?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
How would you format some text using css to be verdana and bold?
Explain what are the steps to be taken to schedule the report?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
what is the difference b/w the refresh and buffered data?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is top business?
What is Indexing? how did u implement indexing?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
How to schedule the report in b.o?
What are the steps to be taken to schedule the report?
How we drill up week to month?