Data diffs are easy when the tables are already exactly the same. The union/except query you wrote returns no results. It's much harder when many things are wrong at once, and you have to debug: - Do schemas match?…
At best, Informatica could output the diff of two tables to another table. But the paradigm is very limiting. I'm not sure if you can dynamically change the mappings every time you feed it a new table (different primary…
Data diffs are easy when the tables are already exactly the same. The union/except query you wrote returns no results. It's much harder when many things are wrong at once, and you have to debug: - Do schemas match?…
At best, Informatica could output the diff of two tables to another table. But the paradigm is very limiting. I'm not sure if you can dynamically change the mappings every time you feed it a new table (different primary…