Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Handling Duplicate Group Rows

Handling Duplicate Group Rows

Sometimes duplicate rows occur in source data. The Integration Service can pass one of these rows to an XML target. You can configure duplicate row handling in the XML target session properties. You can also configure the Integration Service to write warning messages in the session log when duplicate rows occur.
The Integration Service does not write duplicate rows to the reject file. The Integration Service writes duplicate rows to the session log. You can skip writing warning messages in the session log for the duplicate rows. Disable the XMLWarnDupRows Integration Service option in the Informatica Administrator.
The Integration Service handles duplicate rows passed to the XML target root group differently than it handles rows passed to other XML target groups:
  • For the XML target root group, the Integration Service always passes the first row to the target. When the Integration Service encounters duplicate rows, it increases the number of rejected rows in the session load summary.
  • For any XML target group other than the root group, you can configure duplicate group row handling in the XML target definition in the Mapping Designer.
  • If you choose to warn about duplicate rows, the Integration Service writes all duplicate rows for the root group to the session log. Otherwise, the Integration Service drops the rows without logging any error messages.
You can select which row the Integration Service passes to the XML target:
  • First row.
    The Integration Service passes the first row to the target. When the Integration Service encounters other rows with the same primary key, the Integration Service increases the number of rejected rows in the session load summary.
  • Last row.
    The Integration Service passes the last duplicate row to the target. You can configure the Integration Service to write the duplicate XML rows to the session log by setting the Warn About Duplicate XML Rows option.
    For example, the Integration Service encounters five duplicate rows. If you configure the Integration Service to write the duplicate XML rows to the session log, the Integration Service passes the fifth row to the XML target and writes the first four duplicate rows to the session log. Otherwise, the Integration Service passes the fifth row to the XML target but does not write anything to the session log.
  • Error.
    The Integration Service passes the first row to the target. When the Integration Service encounters a duplicate row, it increases the number of rejected rows in the session load summary and increments the error count.
    When the Integration Service reaches the error threshold, the session fails and the Integration Service does not write any rows to the XML target.
    The Integration Service sets an error threshold for each XML group.