Answer Posted / nethaji

Yes,We can connect two fact tables by using confirmed
dimension indirectly or directly by confirmed fact.Here when
a fact appears in more than one fact table we can join using
this fact.
eg:
fact table 1 fact table 2
------------ ------------
measures maesures
revenue <=======> revenue

How to calculate fact table granularity?

1069

---

What is dimension modeling?

1178

---

What are the stages of datawarehousing?

1047

---

Explain me what is vldb?

981

---

What is MODEL is Data mining world?

2660

---

Explain why should you put your data warehouse on a different system than your oltp system?

987

---

Explain is fact table?

972

---

What is the difference between olap and datawarehosue?

1004

---

Explain the difference between view and materialized view?

980

---

What are fundamental stages of data warehousing?

1084

---

Where do we use semi and non additive facts?

1037

---

Why facts table is useful in representing the data?

1046

---

What is the difference between snowflake and star schema?

1096

---

Explain how to generate iqd file from framework manager?

993

---

Explain what is type 2 version dimension?

1068

---