how can one connect two fact tables ? is it possible ? how?
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
| Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
Explain the definition of normalized and denormalized view and what are the differences between them?
What function should we use to display the value entered or selected by a user in response to a prompt?
What is a Decision Tree Algorithm?
Explain the difference between oltp and olap?
How do you define data block size?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
What is a functional dependency f said to be minimal?
Explain functional dependency?
How to pivot data using informatica when you have variable amount of pivot rows?
What is difference between e-r modeling and dimensional modeling?
What is your spectra photometer working principles?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is data stream and data adaopter. Is it same are different? Explain?
Tell me what is full load & incremental or refresh load?
What is data mart in data warehouse?