Category Archives: BI

(Deutsch) 2 Datenbanken vergleichen

Sorry, this entry is only available in German.

Checking two tables for equality

When developing DataWareHouses you often have to check if a new/optimized ETL has same results as the old version. So you have to check, if two database tables contain the same rows.

For two tables at the same database, or databases that are connected, this can be done by the following SQL statements.

Continue reading

Tagged , , , , ,