Answer Posted / sandeep.t nizamabad

THE ARCHITECTURE CONTAINS THE FOLLOWING COMPONENTS
1.OLTP SYSTEMS
2.STAGING LAYER
3 DATA WAREHOUSE
4.DATA MARTS
5.REPORTS
6.BUSINESS USERS

Compare and contrast aggregates & indexes

3750

---

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

932

---

What is degenerate dimension table?

979

---

What is Discover and Execute in XMLA?

2393

---

Can a dimension table contain numeric values?

1040

---

What is metadata in context of a datawarehouse and how it is important?

1031

---

What is a staging area? Do we need it? What is the purpose of a staging area?

979

---

Suppose we want to display zero when null values coming to report how can we do that?

911

---

Can decision tree be implemented using SQL?

2106

---

How can you implement many relations in star schema model?

980

---

What are snapshots? What are materialized views & where do we use them?

1026

---

What are the different models used in cluster analysis?

943

---

What is execution plan?

1187

---

Explain why dimenstion tables are denormalized in nature?

899

---

What are the advantages of query studio compared to report studio?

881

---