Answer / Farha Adil

In a data warehouse, you can create multiple non-clustered indexes on a single table but only one clustered index. The primary key constraint is used to create the clustered index by default if not specified otherwise. When a table with a unique ID (such as a primary key) is truncated or deleted, all data is removed and the structure remains intact.

What are Aggregate tables?

1 Answers  

---

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

1 Answers  

---

what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-

4 Answers  

---

Explain what are the steps to build the data warehouse?

1 Answers  

---

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

1 Answers  

---

Explain the differences between normalizer and normalizer transformation?

1 Answers  

---

wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.

1 Answers  

---

What are fact, dimension, and measure?

1 Answers  

---

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

2 Answers   Thomson,

---

Explain what is a view as it relates to system modeling?

1 Answers  

---

Give some difference between oltp and olap.

1 Answers  

---

What is difference between model & package?

1 Answers  

---