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 ...]);
Previous topic Moving the FACT table records in Microsoft SQL Server databases Next topic Deleting the records from the FACT table in Microsoft SQL Server databases