Tasks

Back Next

Schema mismatch handling

You can choose how

Data Integration

responds when it encounters a mismatch between a file and the selected schema.

When you run a mapping through a mapping task, you can configure an advanced option that specifies how

Data Integration

handles mismatched schemas:

Skip mismatched files and continue. When

Data Integration

finds a schema mismatch, it stops searching for other errors in the same file and writes that error to the log.

Data Integration

doesn't process any other records from that file and continues with the next file.

Stop on first mismatched file.

Data Integration

stops all processing when it finds a schema mismatch error, and it writes the error to the log.

Data Integration

does not roll backfiles processed before the error was found, and it doesn't process the file containing the error.

When you run a mapping in the Mapping Designer,

Data Integration

evaluates every file and skips the entire file when it encounters a schema mismatch.

Schema mismatch handling doesn't apply to mapping tasks that are based on mappings in SQL ELT mode.