how to filter on target table
edited Aug 14, 2018 5:04AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hi,
I am trying to perform a "UPDATEDELETES" on a deleted row from the Source. On the Target I want to be able to filter when the target column DELETE_FLAG='N' only. The Source and Target tables do not have a primary key column.
I tried to use the FILTER ( DELETE_FLAG='N') and the WHERE ( DELETE_FLAG='N') clause but get errors.
The FILTER clause gives message: OGG-01298 Column function diagnostic message: could not find column DELETE_FLAG
The WHERE clause gives message: Error in WHERE clause. Unrecognized clause or element.
Is this possible? All I keep seeing are functions that operate on the Source columns.
0