The Data Reference workbook defines the data paths to your source dataset, target dataset, and data mapping workbooks. In addition to defining the data paths, the Data Reference workbook allows you to selectively query your source and target datasets.
Source definition query
The SourceDefinitionQuery column can be used to write an SQL query to select a subset of the source dataset being mapped to the target dataset. For example, use Type = 0 to only select records where the attribute type equals 0 to load into the target dataset.
Target delete query
The TargetDeleteQuery column can be used to write an SQL query to selectively delete data from the target dataset before loading. For example, 1=1 truncates all existing data in the target dataset.