There are two or more source tables each having different load frequencies(meaning these tables might get refreshed on different dates). Now, these two sources load the same target table.
The approach used when loading this target table is Incremental Load.
Is there a way we can load this target table ensuring that there is no data loss because data from one source might get loaded on one day while the next one is not. Is there a method to go about doing this?
There are no timestamps in the target table.
Thanks in advance
![Smile :)](./images/smilies/icon_smile.gif)