WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ?
Thanks In advance Prakash
- 2 Answers
- 5946 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
Explain about a time when you discovered a more efficient way to do a work task?
How to open a universe with out using the Designer ??
Explain when to use local filter and when to use global filter?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
explain in detail about type 3?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is thumbnail?
Can we create universe with no cache??
What is the difference between the public object&schema object?
How to execute the plsql procedure from the report by clicking with mouse?
what are the tables used in health care domain project and columns used in report?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain when we use aggregate awareness function in designer?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
