Please enable JavaScript to view this site.

 

 

The inputs and outputs from each phase are saved in a structured way (see figure below).

 

1.Extract-Phase: The non .QVD tables should be stored in 01_Extract/extract. The transformed tables in .QVD format should be stored in 01_Extract/transformed.

2.Transform-Phase: In the 02_Transform/transformed folder, the transformed tables (i.e. new fields and new keys) can be stored. The created views are stored in the views folder.

3.Generating Events-Phase: 03_ProcessLogGeneration is the folder, where the output of MPM_ProcessType_03_ProcessLog is stored.

oIn the DataSource_EventLogs folder, the data sources of each event are stored.

oIn the DataSource_Repositories folder, the tables with the activity definitions (activityScenarioFieldsTable) are stored.

oIn debugEventSourceLog, the mpm tables from each data source are stored for debugging purposes.

oIn the debugEventSourceTables, the tables of each script tab can be stored if any problem occurs.

oFinally, in the MPM_Model will be stored the final model of your process.

 

Folder Structure ETL

 

© by MEHRWERK GmbH