Avoid using custom programs

• Recommendation: Whenever possible, define a transformation using the DMW user interface, including standard Oracle SQL and custom functions, as opposed to custom programs.

• Rationale: If you use custom programs, you are responsible for the coding. This isn't a scalable approach. In addition, custom programs are not as re-usable as transformations that you define in the DMW user interface.

• Additional information: For more information about using custom functions, see the Guidance for DMW Implementation and Configuration document.

  The only scenario in which we recommend using a custom program is when defining the Filter Drive table, which is marked with the table SUBJECTVISIT SDTM Identifier. In an ideal study design, that is the only custom program used.