Is using UNION in satellite template a good practice?
I remember from the class that it is not. I don't remember why. I have seen the use of union where
new and updated records together with the deleted records are all being added into the satellites in one sql.
Is this allowed in databault? I was thinking of creating two different templates, one for insert and a separate one for delete.
Just want some feedback on this topic.