Answer / srini

Using conformed diemsion tables

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.

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".

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

Answer / ambareesh

vinod kumar reddy told wrong answer.
using pk and fk we can connect 3 fact tables

Answer / x

Through primary keys and foreign keys

Answer / chitwan

Using Stitch Query Concept.

Answer / moon

Bhadra given currect answer ....................

Answer / ganesh

we can connect two r more fact tables using dimension tables

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??

Define query studio?

0 Answers  

Column level security in report

4 Answers  

Is cognos models are version compatible?

2 Answers  

how many types of keys are there i.e primary key and foreign key etc..?

2 Answers   IBM,

how to Explain a complex report at the time of interview ? please post the answer very urgent?

3 Answers   HSBC, IBM, TCS,

what is session parameters? what is use?

1 Answers   HCL, Satyam,

which difficult you faced in your project?

1 Answers   IBM,

How to pass parameter value into html design page?

1 Answers  

What is a dimension?

0 Answers  

What is Fullouterjoin?

0 Answers  

What is a scope? can you tell me one example for scope?

1 Answers   CTS, IBM, TCS,

----------------Diff b/w Dimensional modeling and Relational modeling?

2 Answers   Cap Gemini, L&T,