STG 2
Start by running the stg script
Locate name of install script for stg2 here
Run the mfp.initial_load procedure on the stg database
PROD
Run the install script for prod
Locate name of install script for prod here
Run the mfp.initial_load procedure on the prod database
Make sure that you are not already using the data_element ids
STG2
If you are using stg2 you should double check the raw views and run the MFP stg_run to make sure that all data is transferred correctly from there to the mfp layer on prod (through prep and mfp on stg)
STG2
Make sure to add all ‘mfp’ stg_element_groups into daily run ctr.stg_run_group so that the MFP module is updated in your daily job.