Triggering a table in OLTP system problem

Asked By 0 points N/A Posted on -
qa-featured

Hello there!

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…

Thank you…

SHARE
Answered By 10 points N/A #107484

Triggering a table in OLTP system problem

qa-featured

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.

Regards
Thompson Locker

 

Related Questions