If a procedure name is entered in the Post Load Procedure drop-down field of a Load table's Properties, then this procedure will be executed after the load has completed and after any after transformations have occurred.
Click the Rebuild button to start the process of generating a new procedure. The Regenerate button is used to regenerate the Load table's existing post-load procedure.
Refer to Load Table Column Transformations for details.
Post-load procedures can either be manually generated from a RED provided procedure outline or generated leveraging a RED template—refer to Rebuilding Update Procedures for details.
For custom database targets, the option to use Post Load Scripts is provided, as an alternative to post load procedure. Post-load scripts can be generated using a RED template—refer to Rebuilding Update Procedures for details