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 to connect three fact tables?

Answer Posted / bhadra

Any two fact tables are connected via a dimension table only
so to connect 3 fact tables we connect each two of them
using a dimension table in between them
Join the primary key from the fact table to the foriegn key
in dimension table

F1 - D1 - F2 - D2 - F3

F* are the fact tables and D* are dimension tables

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of studio present in Cognos?

1038


whats the difference between previous version of cognos and cognos 8 BI?

5532


What are the other methods working as deployment functionality?

951


How do we drill through from a powerplay cube to reportnet?\

2357


How can create users and permissions in cognos?

962


What you mean by drill across and what is the difference between drill through, drill across?

1029


What are the methods by which it non-durable model could be changed into the durable model?

964


What are the considerations regarding performance kept in mind while setting up cognos?

971


What is the deployment requirements used in cognos?

1659


how to test reports in cognos?

1032


Write various indexes used in cognos?

973


what are the features in cognos8ui

2058


can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

2066


how can I test reports in cagnos?

1158


What is Additive function?

2038