Hi All,
I have attached data in my fact table and i am considering the transaction date to do incremental load.
Currently it captures the transactions from 12:00:00 AM to 11:59:59 PM . For example,If i want see the sales data for 11/29/2017 then it will be sum of all the transactions that happened between 11/29/2017 12:00:00 AM to 11/29/2017 11:59:59 PM.
But i have a different business requirement where i need to consider the data from 8:00:00 AM to 8:00:00 AM.
In this case sales for 11/29/2017 would be the sum of transactions that occurred between 11/29/2017 8:00:00 AM to 11/30/2017 8:00:00 AM.
how can we achieve the same.
Thank you.
Regards,
Viresh