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
What is the difference between the public object&schema object?
Can we create universe with no cache??
What are the data types present in bo? What happens if we implement view in the designer and report?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
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.
Give some information on report bursting?
What is package in BO
Explain the difference between detect alias and detect context?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Explain in detail about type 2(scd),
How can you first report in Business Objects by using broadcast agent?
explain in detail about type 3?
what is document design in boxi,have u participate in that
What are the steps to be taken to schedule the report?