Is it Possible to do a right Join In Enrichment Activity?

[srikanthr646926]

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.

[Marcel_Szimonisz]

Hello,

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.

Marcel

[srikanthr646926]

Thanks Marcel , I did it with Exclusion Activity for my requirement

[Marcel_Szimonisz]

yes exclusion is also a solution

Marcel