title: In which manner could we update our data warehouse based on the status changes of already transferred records in live DB?
body: <p>I have a E-Commerce website which I want to create a data-warehouse out of its relational database. Consider I have a payment table in my relational database, each payment has status which would change during payment process (Imagine these status could be: New, Processing, Succeed, Failed). Now I want to have a PaymentFactTable in my warehouse so that each record in it represents "All Payments in a specific hour with specific status" then on each I have some facts like Total Payment Amount or Total Gateway Interest. But there is where my problem raises. Imagine my ETL service has transferred and grouped payments of an hour into my warehouse, but these payments would change their status during next hour, so ... what should I do? and how should I update payment groups in warehouse, one problem is I don't have any clue in warehouse to find and update the group of changed payment. And the other question is how warehouse should be informed about these status changes in order to update its data?</p>