Data processing types and modes
DMW supports two types of data processing: Reload processing and Unit of Work processing (UOW). The unit of work can be either Subject or Subject Visit.
You set the data processing type for a table in its UOW Processing Type attribute in the clinical data model. Possible values include: Non UOW (Reload), Subject, or Subject and Visit. In a target table, this value determines the preferred processing type for transformations writing to the table. For UOW processing to actually occur in transformations, source tables must also be defined with UOW processing.
Both Reload and UOW processing can be run in either Full or Incremental mode. UOW Load mode is available for loading data. You select the mode—Full, Incremental, or Load—when you schedule or submit a job.
Both types of processing require a primary key on the target Table instance. It is not necessary to have a primary or unique key defined in an external source. For example, external SAS files that do not have a primary key defined can be loaded as long as the target table has a primary key.
The target tables of validation checks, which are created by the system, use Reload processing.