Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37397 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
What are the advantages of cold fusion?
What are the mapping paramaters and maping variables?
What is the difference between aggregate table and materialized view?
What is the difference between view materialized view and view?
What is the difference between a primary and secondary actor in use case modeling?
What is static and local variable?
Explain what are the methodologies of data warehousing?
Explain what is power center repository?
Explain what are the different types of data warehousing?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
Where do we use semi and non additive facts?
What is the difference between star and snowflake schemas?
How to generate the cubes in framework manager?
Explain what are components of report studio?
What is the difference between datawarehouse and bi?
