Data Scrubbing

• Most of the job of data warehousing

• State of the Practice: Use Excel

  • List all the sources
  • Write the transformation in text

• Make this model driven

  • Schema merge to find candidate mappings
  • Use constraints to derive mappings ?

Previous slide

Next slide

Back to first slide

View graphic version