Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODQ capability

User_CC5FHSep 30 2011
hi

I am not very familiar with ODP/Q, but like to find out whether the following is feasible with ODP/Q

1. How to detect and alert when data inconsistency happen in the data source and target, For example, there is 1000 sales orders in the source DB, but there's are only 998 order in the target DB?

2. Is there a way to detect and alert sudden drop and growth (i.e. %) of transactions on different attributes for both source and data warehouse? Do I need use write script to monitor the Source and Target DB?

Thanks in advance

Comments

758358
Hi,

if there is a message in the queue ready for processing then a DQ attempt should pick it up, if there isn't then your DQ should wait the specified duration (as given in your DQ options) and then timeout with a specific ORA- message, it is up to you how you handle this in .NET - catch the error, go to sleep for 5 minutes and then try again ?

Thanks
Paul
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 28 2011
Added on Sep 30 2011
0 comments
190 views