You can translate the question and the replies:

How to compare two views in denodo

Hi, Is there any way in testing tool to compare the the values of two views and send a alert with the MISSING VALUES in case ther's a mismatch. I tried to use select * from view 1 in execution directory and select * from view 2 in result directory. It works but it just send the detail about the 1st missing record not all the missing record
DENODO Denodo Testing Tool
user
15-08-2017 13:53:52 -0400
code

1 Answer

Hi, The Denodo Testing tool is built in a way to do automated testing that can quickly identify if there is a mismatch between views before and after any changes. This way, the development team can be sure that no changes have adversely affected the results. If you would like to get the mismatch between two views, you may create a view by doing a MINUS operation over both the views. Then execute this view to find the difference between the views. Hope this helps!
Denodo Team
16-08-2017 06:06:54 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here