Hi all, hope i can get some help here.
How can i make sure when joining data in ODS, it will only join data with the same batch of extraction?
i.e. Products table has data row 1 - 10 from yesterday, row 11 - 20 from today.
I would like to join yesterday sales record with data in Products table row 1 - 10 only, and today's sales record with data in Products table row 11 - 20.
Thanks in advance.....