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

    Details

    • Type: New Feature
    • Status: Open
    • Severity: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Star-Modeler (Plugin)
    • Labels:
      None
    • 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

      Description

      • 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.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: