Hi everybody
We have a distributed database system in which data from a set of tables in
a sub-system S1 flows into another sub-system S2 using snapshots. This data is
referential data in the S2 and is not modified there, but it is used in a
different manner. The moment the data gets refreshed into the snapshot, it
needs to be sent into another set of tables with additional mappings, etc.
We were trying to achieve this by using db_triggers. Each snapshot has a
db_trigger that updates a master table whenever an update/insert occurs
in the snapshot. The data gets refreshed into the snapshot, but the db_trigger
is not fired and hence the master table is not getting updated.
The questions here are:
1) Can we have db_triggers for Snapshots, since they are READ-ONLY?
2) Is there anything else we have to ensure before we use the db_trigger?
3) Are there any alternative methods?
I will appreciate if you guys can send your responses directly to my
email account: krish_at_mumbai.tcs.co.in
Thank you
Regards,
Krish
