how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 35158 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
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 difference between e-r modeling and dimentional modeling?
Explain er diagram?
What is a general purpose scheduling tool?
What are the different types of segments?
What are the stages of datawarehousing?
Explain what are necessary tasks to install reportnet software?
Which columns go to the fact table and which columns go the dimension table?
Fact table is in normalized or de-normalized form?
What is crass reference table?
What are the different types of datawarehosuing?
What is normalization, first normal form, second normal form, third normal form?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
if you use oracle sql*loader , how do you transform data with it during loading?
What are the different types of scd's used in data warehousing?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
