Please enable JavaScript to view this site.

 

 

MPM EventLog Generation Apps contains the following apps (for naming convention the "_Process_" will be replaced with the process name):

 

MPM_Process_01_QVDBuilder

In this app, .QVD files from the database are extracted. Consequently, this app is used in the Extract phase.

MPM_Process_02_Transformed

In this app, you can transform the data from the first app by creating for example new fields and new keys.

 

We highly recommend to create the data view files here, which are joins of tables that are often used in the third app. Therefore, this app is used in the Transform phase.

MPM_Process_03_ProcessLog

In this App, the events for the event log are defined. This App includes the required methods and structure to accomplish this task. Consequently, this app is used in the EventLog Generation phase.

 

 

The MPM EventLog Generation Apps have a 4-Layer model, which is presented in the following picture:

 

Structure ETL model

 

This structure is built to maintain the tables from one app independent from another and you can naturally apply your data architecture techniques to tailor the process to your needs.

 

In this chapter, there is one example that is explained by parts on each section. At the end of the document, you will find a recommended folder structure, which is mentioned at each eventlog generation phase.

 

© by MEHRWERK GmbH