Customizing the MDEPerson_3 job

Use this procedure to customize the MDE_Person3 job for your MDM environment.

1. In the Designer client, open the MDEPerson_3 job.
2. Double-click the Update_Min_Audrecno connector stage.
   1. On the DB2 Connector dialog, select Input > Properties.
   2. Enter the MDM database connection information in the Database, User name, and Password fields.
   3. If you are using a model that is different from the default MDM party model, then you must update the following SQL in the After SQL field to reflect the member type used in your model.

      update mpi_seqgen set seqnum = (select seqnum from mpi_seqgen where seqname ='maxaudrecno_person') where seqname='minaudrecno_person'

3. Double-click the Update_MinRecmtimeId connector stage.
   1. On the DB2 Connector dialog, select Input > Properties.
   2. Enter the MDM database connection information in the Database, User name, and Password fields.
   3. If you are using a model that is different from the default MDM party model, then you must update the following SQL in the After SQL field to reflect the entity type used in your model.

      update temp_recmtime_watermark set min_recmtime = (select max_recmtime from temp_recmtime_watermark where enttype='mdmper') where enttype='mdmper'

4. Open the Sequential_File_6 stage. Select Output > Properties tab, and then select the Target folder. In the File field, type the full path and file name of the file that data is read from.
5. Open the Sequential_File_7 stage. Select Input > Properties tab, and then select the Target folder. In the File field, type the full path and file name of the file that incoming data is written to.
6. Save the job and then compile the job.