I have a replication activity that works fine. We have another requirement where the values should be replicated in the Target Notes DB from the DB2 Source column based on some condition.
Source col - Cost_Price
Target col - Cost_Price
Condition - when When D_ITEM_BRANCH.ITEM_BRANCH like ‘110___’ and (D_ITEM_BRANCH.GEN_LEDGER_CD LIKE '___R' )
The query is how & where should i specify this condition ???