Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain what are necessary tasks to install reportnet software?

854


Explain a linked cube?

902


How much data hold in one universe.

927


What is difference macros and prompts?

2216


Why should we use data ware housing and how can you extract data for analysis with example?

931


Suggest a good author for hyperion in data warehousing?

883


Explain what are the different types of data warehousing?

910


What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

1112


How to create diff. Types of templates?

979


Explain what is the difference between view filter and report filter?

915


What is the extension of file to save template?

947


How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

946


Explain what is fact less fact table? Where you have used it in your project?

860


Explain which columns go to the fact table and which columns go the dimension table?

865


Explain the main difference between inmon and kimball philosophies of data warehousing?

918