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.

1 answer

  • answered 2022-02-13 16:04 Maciejg

    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

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum