I have one requirement where I need to delta load form one DSO (ZDSO_01) to another DSO (ZDSO_02) in follow conditions:
the DSO (ZDSO_01) is refresh an hourly basis and DSO (ZDSO_02) is refresh an daily basis.
Delete all data from ZDSO_02 every day and load with only delta records form ZDSO_01. I am wondering how can I achieve that goal.
Any tips and suggestions??
Thanks in advance.