Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ?
Thanks In advance Prakash
- 2 Answers
- 6679 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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
What Is Snow Flake Schema?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is the difference between condition & filter?
what is xcelsius architecture?
Give some information on report bursting?
Difference between b.o 5.1 and 6.1b?
Explain what are the steps to be taken to schedule the report?
Explain what is the difference between slice and dice and cross tab report?
Can you please send me the migration related issues .
How would you format some text using css to be verdana and bold?
Explain about a time when you discovered a more efficient way to do a work task?
In banking domain how many Fact tables,Dimension table are present?
Explain what are the measure objects?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
