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
what is hints in cognos and where we use it.
how you provide security to reports? How you provide security to packages ?
What is the use of powerhouse?
What are the ways to import data into catalog?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What is the complex report you faced in real time?
What are the components used in web tier?
what is the difference between filter and condition?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
What are the steps to import the two data sources in framework manager?
Can you define a catalog and types of catalogs in cognos?
How do you Parametermap variables in Quiries?
Can you define confirmed dimension?