how can one connect two fact tables ? is it possible ? how?

8 Answers   ABC, Oracle, Patni,

---

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,

---

Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K

6 Answers   Accenture, IBM, TCS,

---

suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

3 Answers   Oracle,

---

What is Active Datawarehousing?

0 Answers  

---

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

12 Answers   Target,

---

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

0 Answers  

---

List down some of the real time data-warehousing tools?

0 Answers  

---

When should you use a STAR and when a SNOW-FLAKE schema?

6 Answers   Accenture,

---

Explain vldb?

0 Answers  

---

What is operational data store (ods)?

0 Answers  

---

What is metadata in context of a datawarehouse?

0 Answers  

---