Prasad

• Jun 15th, 2007

 

Yes. It is possible.? We can connect two fact tables in the universe with the concept of "Aggregate Awareness" concept.

With this concept we can improve the performance of the Universe also....

Thanks Regards,
Prasad

Pratap

• Sep 26th, 2007

 

By using the Conformed Dimension

VAMSIKRISHNACH

 Profile Answers by VAMSIKRISHNACH 

• Dec 7th, 2007

 

Yup ofcourse by fact constellation i.e joining two fact tables and via foreign key relation

jaggu_mandya

 Profile Answers by jaggu_mandya 

• Jan 11th, 2008

 

Yes. It is possible. We can connect two fact tables in the universe with the concept of "Aggregate Awareness" concept.
The process of joining the two fact table is called Fact constellation

Pers.L

 Profile Answers by Pers.L 

• Jan 24th, 2008

 

The only way to connect two fact tables is by using conformed dimension.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Sep 20th, 2008

 

As comment by lot of DWH gurus above, two fact tables can be connected only using conformed dimension, defination of conformed dimension:if one primary key of dimension is defined in two fact tables it is called conformed dimension.

Vamshidhar

 Profile Answers by Vamshidhar 

• Jan 13th, 2009

 

Conformed Dimensions are used to connect two fact tables.