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
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.
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
Why is auto-regression used in forecasting used on cognos platform?
What is a Transformer?
2. What functional area you worked on.
i have one file i saved in csv how can i take these file into framework manager
Define olap designer?
What is Additive function?
Can you define metrics designer?
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
What is the importance of having monitor service in cognos?
What are initial page components of Cognos connection?
Name the types of gateway?
What is cognos reporting tool?
What is a Query Subject?