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 ...])