Golden Gate filter condition on a new source table is checking the previous txn, where as If I use the existing table, it is properly checking the filter on the current txn, very weird situation/ something got enabled ?
example:
Source table -- TABLE_1 (newly created) fields - Field_1, FIeld_2
txn - 1 : values(A,100)
txn -2 : values (B,200)
MAp - Filter ( streq(field_1,'A'))
Ideally txn 1-> should turn out to be true and should replicat, but that is not happening instead filter condition taking previous txn but inserting current values..
Means --> for the txn 2 it is passing the filter (it shouldn't have) and inserting current txn data.
if someone faced a similar problem with filters , please let us know what we are missing on here.