Try doing a left outer join with source as primary and target as the ref link based on key cols. All the null values will be as insert. And others wil be an update. Nite ref should be a full file.
I have not researched on any custom components on CDC as we were able to achieve what we were looking for (Inserts and updates) and deletes is something which we didn't needed as part of our requirements.
