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
Explain what three things do you consider to be the most important factors for a manager?
Which versions are used in the bo dashboard work?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to generate the report from excel sheet?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Can more than 1 metric be applied on an analytic in business objects?
What is aggregate table and aggregate fact table ... Any examples of both?
Explain what would you consider as your biggest achievement and why?
Difference between zabo and webi?
What Is Snow Flake Schema?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What is the dense rank?
When we use aggregate awareness function in designer?