Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37075 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 what is a view as it relates to system modeling?
How are the dimension tables designed?
Explain me what is vldb?
What is MODEL is Data mining world?
How to define a cube??
What are aggregate transformation?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Can we start and stop single session in concurent bstch?
What is Operational Data Store?
What is a view as it relates to system modeling?
What is the working process for application.cfm?
What are the advantages of query studio compared to report studio?
Explain what are the mapping paramaters and maping variables?
What are the different ways to represent the loading of dimension tables?
What is surrogate key? Where we use it? Explain with examples.
