Explain datawarehousing?

0 Answers  

---

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

0 Answers  

---

What is the function of surrogate key in data warehousing?

0 Answers  

---

if we increase the number of dimensions will the rows in fact table increase or decrease??

3 Answers   IBM,

---

what is data validation strategies for data mart validation after loading process

1 Answers  

---

---

What are data modeling and data mining? Where it will be used?

0 Answers  

---

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

0 Answers  

---

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

0 Answers  

---

How can we transform row to column?

1 Answers  

---

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

0 Answers  

---

Hierarchy of DWH?

2 Answers   Accenture, EDS, IBM, iFlex, TCS,

---

What are the vaious etl tools in the market?

1 Answers  

---