I have a Quotation Management system that I built as a CRUD web app.
Over time, I realized I need to improve it so that management can have their reports.
Hence I studied the Kimball method of data warehousing.
I am now familiar with the concept of Dimensional and Fact tables.
On paper and pen, I have identified Quotation Line Item as the Fact table.
My issue is sometimes, the Sales Rep and the Customer have frequent back and forth regarding the Line Items so the line items will change quantities frequently or even removed.
I know that fact tables not supposed to have zero rows according to the Kimball book.
My question is how then do I handle such changes in the fact table?
According to a source, I am supposed to continuously update the fact table.