SQL Server replication
Posted on 2012-09-14
I am employing a star schema on multiple databases. Several Dimension tables are spanned across all of the databases.
For example if I have table1_Dim, That Dimension table is in Database1, Database2, and Database3 to support three different datamarts.
The issue is that table1_Dim must be equal (schema and data) in all three databases, regardless which database table1_Dim was updated in.
if Database1.table1_Dim is updated, then Database2.table1_Dim and Database3.table1_Dim must also be updated.
This is for schema and data.
Can anyone recommend a replication method that works this way?