Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-6890

As a data warehouse designer I need a tool to create a logical metadata domain to capture BI/DWH requirements and do modelling



    • Type: New Feature
    • Status: Open
    • Severity: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Star-Modeler (Plugin)
    • Labels:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • PM Ranking:
      Not Applicable


      • In Spoon we need a new perspective where the user can create new PMD domains, models, dimensions and facts (business tables) without a physical table underneath (top-down approach)
      • We need to be able to specify the name of the physical table underneath the business table without it being present.
      • We need to allow capturing of metadata for each field in a business table: name, description, physical column name, data type, ... source db, source table, source column, ... extra remarks
      • We need to allow the expression of a relationship between one or more business table

      Furthermore it should be possible to do the following with the domain:

      • Export a fancy report
      • Generate a skeleton job that is capable of creating the physical tables, indexes as well an ETL framework.
      • Generate a proper PMD model based on the logical domain
      • Generate a Mondrian schema based on the logical domain.




            • Assignee:
              mcasters Matt Casters (Inactive)
            • Votes:
              6 Vote for this issue
              12 Start watching this issue


              • Created: