one problem with replicating mutation changes to the data lake is it may lose historical data. let's say e-shop customer changes his home address from WA state

one problem with replicating mutation changes to the data lake is it may lose historical data. let's say e-shop customer changes his home address from WA state to CA, if you replicate this new address and delete old address in compaction process, all past transactions may now be associated with the new address, which can lead to wrong conclusions or distortions of past historical reports (WA sales from past month will not be attributed to CA sales)