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.

how to hide the prompts?

7 Answers   TCS,

---

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  

---

Can anybody tell me . Is it required CMS Server for Desktop Intelligence Reports?

3 Answers  

---

am a fresher hw to get real time experience?

1 Answers   Cap Gemini,

---

what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance

3 Answers   Patni,

---

---

it is possible to link two universes of separate functional domain ?

1 Answers   IBM,

---

Difference between scope of analysis in webi and in deski?

1 Answers   CA,

---

There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 Answers  

---

Can we have multiple domains?

3 Answers  

---

Explain how to execute the plsql procedure from the report by clicking with mouse?

0 Answers  

---

If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.

2 Answers   iFlex, Pfizer,

---

What is the merge dimension?

3 Answers   IBM,

---