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

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

what types of challenges we are faced in creating web i reports .can you please explain with some examples.

1 Answers   Infosys,


2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?

1 Answers   iFlex, Patni,


what is universe testing(not mention check integrity)

1 Answers  


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

0 Answers   CTC,


how do u migrate BO 6.x to XI ?

52 Answers   Cognizant, HCL, IBM, Wipro,






i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)

0 Answers  


How many universes are required for a single project,and how many reports are required for a single Universe.

2 Answers  


Can we take report on Excel in Business Objects?

6 Answers   Business Intelligence Analytics, Oracle,


Can anybody tell me what are the tuning problems?

0 Answers  


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  


I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?

3 Answers   IBM,


What is Array bind size in universe? Plz

2 Answers   TCS,


Categories