Create input data models for new data sources by loading an externally-created MDD file

  • Recommendation: When you add a data source whose metadata hasn't previously been used in a specified DMW environment, create the source data model by loading an externally-created MDD file.

  • Rationale: It's quicker and less error prone to define columns and other data model properties in an MDD. In addition, it's relatively easy to modify and re-load an existing MDD file if you need to make changes.

  • Additional information: Oracle Health Sciences Consulting has worked with customers to develop several different MDD generation macros and utilities to further increase the ease of working with MDDs outside of DMW.