Daily fact table loads...

[markp201]

What is best/recommended method to handle loading facts from day to day?

For example, orders and order detail is loaded for a customer but the next day there are no new orders and we want to trend order activity from day to day.

I don't want to duplicate all the old facts again but we want to see the trend "flatline"

If one day I get 100 new orders I want to see that spike in the trendline.

[swuehl]

Shouldn't this be done by tracking something like 'OrderDate'?

Or maybe I just don't understand what you are after and how your data looks like...

[swuehl]

Maybe you are looking for something like an Incremental LOAD approach?

Using QVD files for incremental load ‒ QlikView

[stabben23]

Hi,

I should be supriced if the ordertabel dont contain some kind of status on the order. You should here see when (date) the status is changed on every order.