Requiring all Source Columns in Target
edited Jan 11, 2022 7:21AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
GoldenGate 12.2.0.1 on Windows replicating from Oracle to Oracle. Integrated Extract. Non-integrated Replicat.
How can I require all column in the source table to exist in the target table?
EXAMPLE:
Source
TABLE1
- COL1 NUMBER
- COL2 NUMBER
Target
TABLE1
- COL1 NUMBER
When a record is inserted into TABLE1, I want the replicat to ABEND because the target TABLE1 does not have a COL2 column.
The default (observed) behavior is the data in COL1 is inserted but COL2 is simply ignored.
Thanks in advance.
Tagged:
0