Rebuilding a data warehouse according to the Business Object Model

The BOM is a generic model that abstracts the customer's business processes independently of the operational systems. The business processes are defined by the Business Objects (BO) and contain not only data but also the processing or business logic. The BOs form the basis of the DWH and specify the modularisation on all levels (database, ETL tool, BI frontend). The technology stack is specified by the customer and consists of Teradata (MPP database), Oracle Data Integrator (ETL tool) and tableau (BI front-end). A challenge in the development of the EDWH, especially in ensuring low response times, is the customer's wish to dispense with the aggregation of detailed data in the form of data marts and instead allow analyses at the detailed data level. The PTA develops and implements concepts to guarantee performance requirements based on the customer's technology stack and architecture.