Merging the dimension records in Microsoft SQL Server databases
Before you perform this task, make sure that all the dimension tables are created and have index on the PZID column.
-
Connect to the target database.
-
Merge the records from the source table to the dimension table.
MERGE INTO <TARGET_DATABASE>.<TARGET_SCHEMA>.PR_DATA_IH_DIM_<DIMENSION_NAME> T USING <SOURCE_DATABASE>.<SOURCE_SCHEMA>.PR_DATA_IH_DIM_<DIMENSION_NAME> SON (T.PZID = S.PZID) WHEN NOT MATCHED THEN INSERT (column1 [, column2 ...]) VALUES (S.column1 [, S.column2 ...]);
If you want to merge the dimension records from the source database to the target database, repeat this procedure for all the dimension tables.