Hi Team,
I'd like to suggest the development of a feature that enables us to reload data for specific periods in FDI. Currently, when soft delete transactions occur in the source and are passed to EPM and then to FDI, these deletions aren't captured. This situation necessitates a complete reset of the data warehouse or, in other words, a full reload of the fact table, which is quite time-consuming. It also requires coordination with the EPM Team to initiate the extract from their end. Introducing a feature that allows for period-specific data reloads could significantly enhance our efficiency.
Thanks & Regards,
Vivek Gautam
