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.
Parent topic: External data loads