Load data based on time

vireshkolagimat — Thu, 30 Nov 2017 11:12:20 GMT

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

topic Load data based on time in QlikView

Load data based on time