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
Explain what are necessary tasks to install reportnet software?
Explain a linked cube?
How much data hold in one universe.
What is difference macros and prompts?
Why should we use data ware housing and how can you extract data for analysis with example?
Suggest a good author for hyperion in data warehousing?
Explain what are the different types of data warehousing?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
How to create diff. Types of templates?
Explain what is the difference between view filter and report filter?
What is the extension of file to save template?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
Explain what is fact less fact table? Where you have used it in your project?
Explain which columns go to the fact table and which columns go the dimension table?
Explain the main difference between inmon and kimball philosophies of data warehousing?