how can one connect two fact tables ? is it possible ? how?
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 is an er diagram?
What does level of granularity of a fact table signify?
Explain what is power center repository?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Explain what are conformed dimensions?
What are session timeout and application timeout? Where we have to do this process?
Explain the versions of reportnet?
Explain what is fact less fact table? Where you have used it in your project?
Difference between cold fusion 5 and cold fusion mx 6?
Explain what are the methodologies of data warehousing?
Explain the difference between dw and bi?
What are the steps to build the datawarehouse?
What is "method/1"?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What are different deliverables according to phases?