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

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

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

September 09, 2008 06:34:41	#6
sixto.dsilva	CRM Expert Member Since: March 2008 Total Comments: 49
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.