Answer Posted / mahesh225

A dimension table is created once and shared across multiple fact tables is called confirmed dimension.

www.futuresoftworld.com
www.candygig.com

Thanks

Briefly state different between data ware house & data mart?

1049

---

Store (and count) non-fact records?

931

---

Explain difference between data ware house & data mart?

990

---

What is a data warehousing?

1154

---

What are the different types of data warehousing?

957

---

What is surrogate key? Where we use it?

997

---

What is loop in data warehousing?

1140

---

What are the advantages of raid 1, 1/0, and

980

---

What is the data type of the surrogate key?

1004

---

Explain if a flat file cotains 1000 records how can I get first and last records only?

931

---

What is data warehosuing hierarchy?

1169

---

How to calculate fact table granularity?

1019

---

What are the steps of implementing data warehousing?

1044

---

What are the main steps to build the data warehouse?

1117

---

What is an error log table in informatica occurs and how to maintain it in mapping?

965

---