Hi
I have an issue where I want to delete records in a target DSO, where the record based on key does not exist in the source. This situation arises, because the source data is dropped and reloaded, where the target is not. In some cases this leaves records in the target which are no longer in the source data.
I could put in place a selective deletion of the entire data set I am loading into the target, but this seems like a blunt tool, so was wondering whether there is a way to check whether the record in the target exists in the source, and if not, flag for deletion.
Any suggestions ?
Thanks
Marsy