Skip to main content
- From any program that can run scripts against the logging data database, execute the DDL script called pentaho_mart_<database>.sql, where <database> is the database vendor, such as MySQL, Oracle, PostgreSQL, and alike. These tables are created:
- dim_batch
- dim_date
- dim_execution
- dim_executor
- dim_log_table
- dim_step
- dim_time
- fact_execution
- fact_jobentry_execution
- fact_perf_execution
- fact_step_execution
- From within Spoon, run the job named Fill in DIM_DATE and DIM_TIME. The DI Operations Mart is created.