Extract - ignore filter syntax if only a certain column has changed
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.