Integration Server does not cleanse invalid or inconsistent data. Inconsistent data may include incorrect values, incorrect data types, or non-matching integrity constraints (rows that do not have entries for required key columns). Also, data is inconsistent if the same value is entered in different forms. Inconsistency often occurs when data is drawn from multiple sources or when users enter data incorrectly.
If source data is inconsistent, you cleanse the data. Cleansing data can be a simple process, such as making suspect data into nulls, or a more complex process requiring a data-cleansing tool.