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

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1487


how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

3466


Why is auto-regression used in forecasting used on cognos platform?

542


What is a Transformer?

653


2. What functional area you worked on.

1915






i have one file i saved in csv how can i take these file into framework manager

1539


Define olap designer?

703


What is Additive function?

1560


Can you define metrics designer?

608


hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

1783


What is the importance of having monitor service in cognos?

584


What are initial page components of Cognos connection?

610


Name the types of gateway?

601


What is cognos reporting tool?

615


What is a Query Subject?

663