Answer Posted / santosh

According to Ralph Kimbal, in a data warehouse, a degenerate dimension is a dimension which is derived from the fact table and doesn't have its own dimension table. Degenerate dimensions are often used when a fact table's grain represents transactional level data and one wishes to maintain system specific identifiers such as order numbers, invoice numbers and the like without forcing their inclusion in their own dimension. The decision to use degenerate dimensions is often based on the desire to provide a direct reference back to a transactional system without the overhead of maintaining a separate dimension table.

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

998

---

Explain the hierarchies level data warehousing.

933

---

Explain functional dependency?

1138

---

What are the reasons to use a chameleon method in data warehousing?

1102

---

How are the dimension tables designed?

1041

---

How to test report in reportnet?

1054

---

what are the major three types of modeling used?

1112

---

What are cluster analysis in data warehousing?

1177

---

what are the others of "bad files" and "discard files" when using sql*loader?

2180

---

What is a functional dependency f said to be minimal?

1163

---

What is cubes?

1111

---

Do you view contain data?

1007

---

Can any one explain the hierarchies level data warehousing.

1042

---

Fact table is in normalized or de-normalized form?

1027

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2325

---