My source is a file and I want to check the previous days loads have any additional IDs than new File, if yes I need to delete and update the data for any changes. There are multiple ways to do that, We can do using exclusion activity for the deleted but I am trying to see if we can do using Enrichment activity reconciliation tab to find ids no longer valid. I need something like right join.
Only I can think of is to query anything from second table in right join and then change dimension to first table in the right join select.
Thanks Marcel , I did it with Exclusion Activity for my requirement
yes exclusion is also a solution