Answer Posted / vams_gk

---------------------------------------------------

confrimed
[sales fact]<.........>[customer fact ]
| |
dimentions x,y,z dimentions a,b,c
-----------------------------------------------------

when u applied join between two fact tables u will get a
confriemd dimention

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

1141

---

Why facts table is useful in representing the data?

1051

---

Difference between cold fusion mx 6 and cold fusion mx 7?

888

---

Explain why fact table is in normal form?

1021

---

How can we run the graph? How can we schedule the graph in unix?

1005

---

Explain when do we analyze the tables? How do we do it?

1048

---

I have two universes created by two difference database can we join them in designer & report level? How

1038

---

What is data analysis?

1007

---

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

1013

---

What is conformed fact?

1153

---

what are the other factors of the database on which the loading performance depend?

1959

---

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

968

---

What is cost benefit analysis (cba)?

1046

---

What is dimensional modelling?

1038

---

What does level of granularity of a fact table signify?

1154

---