Thursday, June 23, 2016

Comparing Table Data Between Oracle, Netezza (Two different Source Systems) using Alteryx

Suppose , we have a employee table exists at Oracle database as well as Netezza database.

Now, we wanted to compare the table data at these two sources.
We wanted to see,

  1. What are the records exists only @Oracle
  2. What are the records exists only @Netezza
  3. What are all the records exists in both Oracle, Netezza

Create a Alteryx workflow as follows

Use "Input Data" tool to read the data from employee table @Oracle
Use another "Input Data" tool to read the data from employee table @Netezza

Use "Joiner" tool to join the two sources

Use "Browse" tool to see the results





No comments:

Post a Comment