Interested to Buy Any Domain ? << Click Here >> for more details...
How to connect three fact tables?
- 11 Answers
- 22329 Views
- L&T, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shree uday
As per Srini post, Confirmed Dimension is right,
If a dimension table which is shared by more than one fact
table is called Confirmed Dimension.
But its not advicable, Coz, it will take a time and also it
going to be trouble.
The primary condition is both the dimension should equal
For eg,Time dimesion.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramana reddy
hi,this is ramana reddy from chennai.i hope that everone is
correct their way but thing is to that ,we can conncect 1 r
more then one fact table by using "aggregate awareness"
concept and this process we use to call "fact constilation".
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / ganesh
we can connect two r more fact tables using dimension tables
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prit
if i got u, i would like to know what if i join these 3
tables(nothing but FACT Table) with their keys. Raman, is
COGNOS provides AGGREGATE AWARENESS concept??
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between a cascading report and drill through the report?
what are determinants?
4 Answers College School Exams Tests, IBM,
how can you get the errors in job? when loops are araised we get error?
what are the filters in framework manager and report studio?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
what is an sid (surrogate key)?
Can u please describe the different types of traps with eg. Thanks
i was asked what are the caluclations done by you in your report? plz give reply
my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?
what is model and how to create model and how to test model?
How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
Teradata 
