Basics - How do you connect two fact tables ? Is it possible ?

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 93 of 113

How do you connect two fact tables ? Is it possible ?

Total Answers and Comments: 7

Last Update: January 13, 2009 Asked by: ssaravalli

Sponsored Links

Best Rated Answer

—

Submitted by: Pratap

By using the Conformed Dimension

Above answer was rated as good by the following members:
phdsong, Vamshidhar

June 15, 2007 10:52:49

Prasad

RE: How do you connect two fact tables ? Is it possibl...

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

September 26, 2007 02:16:36

Pratap

RE: How do you connect two fact tables ? Is it possibl...

By using the Conformed Dimension

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 07, 2007 03:24:44

VAMSIKRISHNACH

Member Since: December 2007 Contribution: 7

RE: How do you connect two fact tables ? Is it possible ?

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

January 11, 2008 06:06:56

jaggu_mandya

Member Since: January 2008 Contribution: 9

RE: How do you connect two fact tables ? Is it possible ?

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

January 24, 2008 01:22:15

Pers.L

Member Since: January 2008 Contribution: 8

RE: How do you connect two fact tables ? Is it possible ?

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

September 20, 2008 06:34:41

sixto.dsilva

Member Since: March 2008 Contribution: 59

RE: How do you connect two fact tables ? Is it possible ?

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

January 13, 2009 19:00:21

Vamshidhar

Member Since: February 2008 Contribution: 4

How do you connect two fact tables ? Is it possible ?

Conformed Dimensions are used to connect two fact tables.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank