N/APosted on - 11/08/2011
Can you help me…
I have implemented a trigger on a table in the OLTP system which instantiate a COM object and pass the inserted row for processing. Can this be implemented in a better way?
Please guide me on this…
Triggering a table in OLTP system problem
In case you are able to add triggers, then you will possibly solve the problem that you are having. All you need to do is capture before and after, or you capture just after images and then put them into a simple flat table and use that as your source. As an alternative to doing the same, you can also choose to use the database logs, which may be a bit more complicated, but that will entirely depend on the kind of tools that you are using.
Another thing to note is that when using triggers (basically the update, insert and delete functions), you will note that you will have avoided the need for the 'check for changes' bit, and that is because all changes will be captured automatically.