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 |
WHAT IS SYNCHRONIZATION IN BOXI?
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
How many built-in objects are created in Business Objects repository?
What is mean by stored procedure ? and how we can generate stored procedure universe?
Explain about derived tables?
how to coneect to a server in a business objects
REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.
Can we do the slice and dice in webintellegence?
There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
Explain the difference between union and group?
How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?