Hi,
To consolidate Up,here are the reasons:
It is built over a transformation called External procedure transformations which is active.
By default in the Union transformation properties the active property is enabled and cannot be edited.
Whenever it merges the data, it changes the row num of each row/ record.