Skip to main content
Hitachi Vantara Lumada and 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.