'Informatica. How to reject whole source file if source and target have duplicates
I have a mapping which compares target with source. In expression there is a condition which checks if there are duplicates. How can I stop whole data flow if condition returns true? DD_Reject does not work as it only rejects one record.
Solution 1:[1]
To stop the flow use the available Expression Transformation ABORT function. This will NOT rollback the already process rows though. If you need that as well, then two sessions will be needed, one to check the duplicates, another to perform the actual load, linked with SUCCEEDED condition.
Start -> s_check_duplicates -succeeded-> s_load_data
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Maciejg |