Just wanted to toss this out there and see what others thought.
We are planning on creating a dummy column in our View that will contain just a character value.
So the view would look like:
SELECT Field1, Field2, 'DUMMY'
Then we can set that value via a simply set dest attr policy to 'RESYNC'
This would trigger an instead of trigger on the view and create an event in the event table to resync the object. Being careful of course to insert a different value for the perpertrator field into the event log so as not to fall victim to loopback detection.
This seems like a really easy way to handle this type of thing.
Thoughts? Pros? Cons?
Thanks in advance!