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 111

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

Total Answers and Comments: 6

Last Update: September 20, 2008 Asked by: ssaravalli

Sponsored Links

Best Rated Answer

—

Submitted by: Pratap

By using the Confirmed Dimension

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

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

September 20, 2008 06:34:41

sixto.dsilva

Member Since: March 2008 Contribution: 50

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 confirmed dimension , defination of confirmed dimension:if one primary key of dimension is defined in two fact tables it is called confirmed dimension.

Is this answer useful? Yes | No

Go To Top