How to Automate comparison of result set of same Sql query running on different oracle environment .

[ykumar03]

For eg.I have below SQL query which needs to be run  2 times . First time in a test environment and the second time in the Production environment with different credentials.

Select name,location from EMP where empid in(101,102)

After running the query in Test and Prod Oracle environment.

1.I want to compare the query result from both environments. How many records match/mismatch

2.Empid in Where condition of SQL query should be parametrized. means empid in where conditions should not be hardcoded.At run time I can put any empid.

Is there a way in Power bi by which I can setup/save this configuration and just by one click I can run this?

@Anonymous

[ykumar03]

Thank You

[PaulDBrown · Accepted solution]

Not exactly sure what you mean "run this by just one click"

However...

If you import both sets of data, you can compare them using measures:

Common records = COUNTROWS(INTERSECT(Table 1, Table 2))

differing records table 1 = COUNTROWS(EXCEPT(Table 1, Table 2))

differing records table 2 = COUNTROWS(EXCEPT(Table 2, Table 1))