A Pipeline always produces the following output:
A data file resulting from all of the Pipeline transformations applied.
A numeric count of the records in the resulting data file produced by the Pipeline.
When a Pipeline has a Mapping Group assigned as a transformation, there are additional outputs created:
A file listing the unique values by field that were not mapped.
This file will contain field values for columns to which a Mapping Group was assigned, but the value was not transformed by any of the mapping rules.
A numeric count of the unmapped file list report.
If a Pipeline has a SUM IF transformation assigned, an additional output is also generated with the numeric result of the SUM IF transformation.