Answer / Supriya Suman

Data Block Size refers to the fixed amount of space allocated for a group of rows in a database. It is used to optimize I/O operations by reducing the number of disk reads and writes.

What is surrogate key? Where we use it explain with example?

1 Answers  

---

Code the tables statement for a single-level (most common) frequency?

1 Answers  

---

What are the data marts?

1 Answers  

---

what is difference between drill & scope of analysis?

1 Answers  

---

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1 Answers  

---

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

1 Answers  

---

3.What is fact less fact ?

9 Answers   Accenture, HCL, TCS,

---

What is the purpose of cluster analysis in data warehousing?

1 Answers  

---

Explain when do we analyze the tables? How do we do it?

1 Answers  

---

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

1 Answers  

---

What is Analysis Services?

1 Answers  

---

Explain a relation schema and a relation?

1 Answers  

---