Uploaded image for project: 'Apache Hop (Retired)'
  1. Apache Hop (Retired)
  2. HOP-3923

DimensionLookup: do not create unknown row when dimension table is empty

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Normal
    • Resolution: Fixed
    • None
    • Migrated to GHI
    • None

    Description

      Any time the dimension table is empty, the DimensionLookup transform creates a new line with ID=0 that is treated as a garbage row. Apart from managing SCD dimension tables, this versioning logic could be interesting in other situations related to the transactional works (3rd normal form) where where that rows is not needed. In that case, we would like to have a flag that tells Hop not to create that line if the table is empty defined as false by default.

      Attachments

        Activity

          People

            sramazzina Sergio Ramazzina
            sramazzina Sergio Ramazzina
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: