Hi all,
I have this scenery:
- one table with a pk (one attribute) in two db (both oracle) in different servers (and i can't to use the dblink)
- i need remove rows on target if the pk don't exists in the source

I think so we can to solve it in two ways:
1 - copying the source rows to a temp table on target and running a delete using something as not in or not exists (among temp and target table)
2 - creating a trans getting all rows on target, setting the key to a variable, and for each row returned run a query on source, check if no rows was returned and then, remove the target row (using the variable yet)

Are there a new way (more practical/smart) to do this task?

* PDI CE 4.2.1