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,
Now, we wanted to compare the table data at these two sources.
We wanted to see,
- What are the records exists only @Oracle
- What are the records exists only @Netezza
- 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