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
Difference between e-r modeling and dimentional modeling?
What is a view as it relates to system modeling?
What is informatica architecture?
Explain a linked cube?
Explain which columns go to the fact table and which columns go the dimension table?
Is there any default username & pwd for bo designer & supervisor?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
What is cubes?
Could any one explain me how to create cascading prompts?
What is called data cleaning?
Can you brief about the Data warehouse project you worked on?
What are the various transformation available?
List down some of the real time data-warehousing tools?
What are universe requirements?