Can you explain how analysis service works?

1 Answers  

---

what is the use of surrogate key in businessobjects

3 Answers   EDS,

---

Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---

1 Answers   Principal Finance, PT Metalogix Infolink Persada,

---

Explain datawarehousing?

0 Answers  

---

List any five applications of data warehouse.

0 Answers  

---

what is the difference between aggregate table and fact table ? how do you load these two tables ?

12 Answers   Target,

---

How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 Answers   IBM,

---

What are Non-additive facts?

0 Answers  

---

What is multi-dimensional analysis?

3 Answers   Satyam,

---

if source contain 10records how you identify header and footer

2 Answers   Polaris,

---

what is parallelism?

2 Answers  

---

What is the difference between static cache and dynamic cache?

0 Answers  

---