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?