Did this work during my tenure at The Elite Group.
My initial project at Elite was to build a DataMart as a central repository for future reporting needs. No singular framework existed that could meet the needs of the EDI’s that were expected to be built moving forward.
Over a period of a few weeks, the DataMart was designed and implemented along with a DataQualityControl framework.
Each day, the system loads a snapshot of key fields in the source systems. Over time, this data could be used to meet all reporting needs.