Merging the dimension records in Db2 Database Software
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 temporary table to the actual dimension table.
MERGE INTO PR_DATA_IH_DIM_<DIMENSION_NAME> T USING (SELECT column1 [, column2 ...] FROM <SOURCE_DATABASE>.<SOURCE_SCHEMA>.PR_DATA_IH_DIM_<DIMENSION_NAME>) S ON (T.PZID = S.PZID)WHEN NOT MATCHED THEN INSERT (column1 [, column2 ...]) VALUES (S.column1 [, S.column2 ...])
Previous topic Moving the FACT table records in Db2 Database Software Next topic Deleting the records from the FACT table in Db2 Database Software