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.

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  

---

what is fantrap?

2 Answers  

---

How do u Receive requiremnts from the client?

3 Answers  

---

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

2 Answers   BirlaSoft,

---

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers  

---

what is difference between Rich client web intelligence and Boxir2 web intelligence

3 Answers   TCS,

---

What is the difference between Thin client & thick client?

5 Answers  

---

What are the diffrences between Business Objects 5.1 & 6.5 ?

1 Answers   Siemens,

---

what r the types of joins universe supports

3 Answers  

---

can anybody tell me how many classes where there and objects in each class

3 Answers  

---

What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash

3 Answers   iFlex, Maintec, TCS,

---

in xir2 how to send reports to end user

2 Answers   TCS,

---