This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
How to compare two tables, which are in different databases. Also, these databases are scheduled. One database table is already existing and functional the other database is newly developed. The newly developed table mimics the existing table and is developed in snaplogic. What is the best way to check if the newly developed table mimics the existing table? (The scheduled time interval in which data bases get updated is 5 mins)
I think the easiest, and best way that is simple, is to use the diff snap. Unfortunately, I needed to know WHAT was changed, and have old data for the delets, so I had to emulate the diff snap through a join.
