Hi engiri,
I think you are more concern to the whole process of warehousing
the new data to the DW database and not a specific procedure
that hampers the performance of loading the data.