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 |
bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?
How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
how to limit number of rows in a report in business objects using webi?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
1.what is context? How u create? With example.
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,
9.what are the multidimensional analyses
Is there any other repository domains rather than universe, security, document?
how many times can use the union operator in a report?
Explain what is the difference between business requirement document and use case document.
why we are using derived tables ?how it will help?
i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance