Answer / Shashank Singh

Type 2 version dimensions are used in data warehousing to store historical changes for attributes that can have multiple active values at the same time. This allows for tracking not only the new value, but also the old value and its effective date.

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

1 Answers  

---

what is a hot file, why we need in datawarehousing, where we used in general

2 Answers   Thomson,

---

What is loop in data warehousing?

1 Answers  

---

What is hybrid slowly changing dimension?

1 Answers  

---

4.Explain Snowflkeschema ?

6 Answers   EDS, HCL, IBM, iFlex, TCS,

---

I need to set predefined condition. How I do this?

1 Answers  

---

Why do we use DSS database for OLAP tools?

3 Answers  

---

Explain meta data?

1 Answers  

---

What is cost benefit analysis (cba)?

1 Answers  

---

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1 Answers  

---

What are the steps to build the datawarehouse?

1 Answers  

---

What is DTS ?

1 Answers  

---