Links may not function; however, this content may be relevant to outdated versions of the product.
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