Answer / prakash123

Bitmap Indexes are used in DWH

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.

Can any body will explain about sarrogat key? Thanks in advance...........Prakash

7 Answers  

---

while migrate bo 5.1 report into boxir2 ,what are the problems faced

2 Answers  

---

What is the merge dimension?

3 Answers   IBM,

---

what is document design in boxi,have u participate in that

0 Answers   Accenture, TCS,

---

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.

2 Answers   Wipro,

---

how we transport universes from business objects 6.5 to BOXI R2?

3 Answers  

---

12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?

3 Answers  

---

What is a universe?

8 Answers   TCS,

---

is it possible to export the webi reports to crystal reports?with out using businessview?

0 Answers   CTC, TCS,

---

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?

0 Answers   iNautix, Wipro,

---

When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?

2 Answers   TCS,

---

What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?

1 Answers   NSE,

---