How can I join a data mart and Northwind to populate the fact table in the same data mart?
asked
An interesting question about joining two databases
If these databases are on the same server/instance you can do this using three part name syntax, see below.
select
D.*
,N.*
from
DataMart.dbo.TablefromDataMart D
join
Northwind.dbo.Employees N
on
D.KeyField = N.KeyField
