WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ?
Thanks In advance Prakash
Answers were Sorted based on User's Feedback
Answer / 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 |
How do u Receive requiremnts from the client?
What is the difference between derived table and views? which one gives better performance?
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
What are all difference between business objects 6.5 and xi r2?
difference between web intelligence,crystal reports and desktop intelligents
How we drill up week to month?
Explain how to schedule the report in b.o?
what is profile and packages in BOXI??
. In production reports, some dimensions are missing. how do you load these dimensions in production
How to Implement the the Built-in Strategy Script in BO Designer?
1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.
We can have two separate installations of BOE XI 3.1 on a single server?