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

What is the data type of the surrogate key?

927

---

Can we have multiple application.cfm file in an application?

904

---

What are the different types of schemas used in data warehousing?

899

---

Explain why fact table is in normal form?

916

---

What are algorithms provided by Microsoft in SQL Server?

1980

---

Explain piconet?

896

---

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

916

---

What is a source qualifier?

1023

---

How much data hold in one universe.

927

---

Why is business intelligence (bi) important in data warehousing?

880

---

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

873

---

How can you set the session management?

1049

---

Tell me what is degree of a relation?

933

---

What are the stages of datawarehousing?

949

---

How to improve session performance in aggregator transformation?

930

---