To configure a PowerCenter mapping to commit target data on every row add a Transaction Control Transformation (TCT) to the mapping before the target with the following expression:
This will commit after every record sent to the target, regardless of the buffer block size or target commit interval.
Doing this is generally not recommended as it will adversely affect performance. One of the most common reasons to implement this is when there are duplicate rows in the source.
For a more effective and efficient ways to do this refer to the related articles.
PowerCenter Transformation Language > "Variables" > "Transaction Control Variables"
Handling duplicate rows using a PowerCenter mapping (15175)
Using Transaction Control to Restart Failed PowerCenter Sessions (15149)
HOW TO: Fail a session in PowerCenter and rolls back if any of the lookups fail in a mapping or the ports are null/empty (23044)
What can we do to improve this information (2000 or fewer characters)