WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ?
Thanks In advance Prakash

Question Posted / prakash123

2 Answers
6726 Views
BirlaSoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash..

Answer / prakash123

Bitmap Indexes are used in DWH

Is This Answer Correct ?

7 Yes

0 No

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash..

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

Post New Answer

More Business Objects Interview Questions

Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.

4 Answers TCS,

I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )

6 Answers Exilant, Siebel,

How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?

2 Answers Wipro,

Difference between b.o 5.1 and 6.1b?

0 Answers

What are templates? Explain what you have created?

1 Answers

what are cascading prompts explain with steps

4 Answers

What is Designer?

2 Answers

Can any one say me wat does"maintanence of universe" means wit?

2 Answers Business Intelligence Analytics, NAL, TCS,

How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".

3 Answers

If there is no common dimension? Is it possible to combine two different dataproviders?

7 Answers

how many reports have u created ? explain a few.

0 Answers Bank Of America, TCS,

HI, can anybody explain me how performence will decrease if we create objects using derived tables ?

2 Answers

For more Business Objects Interview Questions Click Here