Clear all

Using UNION in satellite load template

Posts: 7
Topic starter
Active Member
Joined: 2 years ago

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.

4 Replies