Search code examples
informatica-powercenter

Informatica Workflow Only Loading One Target Row

I have a workflow in Informatica with 261 records in the source table and am trying to load into another. However, the workflow only loads one row. The workflow Task Details show that all 261 records were successfully extracted from the source table, but only one row is inserted into the target. The session log didn't seem to be very helpful. I feel like the issue is an option flag or check-box I'm missing somewhere. Here's a section of the session log:

enter image description here

How can I set up the workflow so that all records are loaded?

* Screenshot UPDATE *

enter image description here

Solution

  • It was an aggregator issue. I edited the Group By ports so that they didn't have the same values across all rows.