how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 34679 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
Explain how are the dimension tables designed?
What are the differences between star and snowflake schema?
How to generate the cubes in framework manager?
What is core dimension?
Explain what is the difference between stop and abort?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what is the metadata extension?
Explain what are the various file formats involved in reportnet?
Why should you put your data warehouse on a different system than your oltp system?
What are the steps involved in creating dimensional modeling process?
What is meant by metadata in context of a data warehouse and how it is important?
Explain the different types of data warehousing?
How can you import tables from a database?
What is scd1 , scd2 , scd3?
What is the 4 + 1 view model as it relates to system modeling?
