Explain why dimenstion tables are denormalized in nature?

0 Answers  

---

Explain can a dimension table contains numeric values?

0 Answers  

---

Compare and contrast aggregates & indexes

0 Answers   IBM, TCS,

---

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

0 Answers   Wipro,

---

What is the difference between an ODS and a W/H?

1 Answers   Barclays,

---

---

What is ?Data Warehousing??

3 Answers   Accenture,

---

How to add a number to a macro variable?

0 Answers  

---

Tell me what is degree of a relation?

0 Answers  

---

Explain conformed fact?

0 Answers  

---

What is degenerate dimension table?

0 Answers  

---

Explain what are fact, dimension, and measure?

0 Answers  

---

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,

---