To override the default query in a mapping with an advanced query, you must define a mapping parameter with the name as
CONDITIONS
and set its value to
$CONDITIONS
. You must then include
$CONDITIONS
in the WHERE clause of the custom query. For more information about configuring the custom query, see the following Informatica Knowledge Base article:
KB 564550