Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Schema mismatch handling

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.

0 COMMENTS

We’d like to hear from you!