Answer Posted / sowmi

DWH Architecture:

It has 3 layers:

1.Staging
2.Integration
3.Target

In staging we get the raw data.In integration we process i.e
we cleanse the data.In target the data is ready to be used
by end users for report generation.

Why is chameleon method used in data warehouse?

1166

---

Explain what is the difference between olap and datawarehosue?

1092

---

Who needs data warehousing?

1066

---

I need a good brd and uc template?

1087

---

How can we run the graph? What is the procedure for that?

946

---

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1131

---

What is mean by aggregate aware?

1086

---

In document how to create metrics?

992

---

Can we take backup when the database is opened?

1051

---

What is scd1 , scd2 , scd3?

1088

---

Explain what are the mapping paramaters and maping variables?

1070

---

What are non-additive facts in detail?

995

---

What is Active Datawarehousing?

1016

---

What is fact less fact table? Where you have used it in your project?

1011

---

What is the difference between metadata and data dictionary?

1142

---