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
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
can anybody tell me about complicated object you have created
what is xcelsius architecture?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
What is difference between webi and infoview?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
what is the difference b/w the refresh and buffered data?
What is the profile and package?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
What is report template in b.o?
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,
Can we create universe with no cache??
Explain how we drill up week to month?