GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Extract - ignore filter syntax if only a certain column has changed

edited Nov 11, 2017 4:01AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Good day

I have a source schema with 45 tables.

A lot of these tables are wide, with 100+ columns.

Each table has several audit columns (who changed , when changed etc)

During normal activity , some , most or all columns get changed including the audit columns. I would like to extract this activity

BUT

I need to exclude , possibly using FILTER on the EXTRACT, any updates that involve solely the audit columns

I can filter the extract quite easily for updates to just the audit columns, but it gets long winded if I try to create a filter for every table, that tests to see if the audit columns and one or more of possibly hundreds of columns are also present in the update.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center