So, we have the sales amounts expressed in different currencies and we must address this issue before going too far. The CFO can't get any sleep until we fix the exchange rate adjustment, which is actually generating a distortion in the bottom line and undermining our CV.
The exchange rate is stored in a different fact table and is related many-to-many to both
FactResellerSales tables. How to deal with that?
Well, I beg your pardon, I consider myself a practical person and sometimes lazy; as usual, different DBAs will have different solutions, more or less elegant. I personally prefer modifying the fact tables in this situation. Given that the exchange rate of a currency in the ...