Skip to main content
Pentaho Documentation

Create the DI Operations Mart

  1. 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
  2. From within Spoon, run the job named Fill in DIM_DATE and DIM_TIME. The DI Operations Mart is created.