Download Specifications

As detailed in the staging area section, the mapping from the Staging Data Model to use cases, called a download specification provides an efficient way to manage the sourcing of data into the OIDF staging area. This is done by mapping the staging model at a column level to use cases. This mapping information is embedded in ERwin at a column level using metadata called User Defined Properties (UDPs).

The Download specifications can be extracted using pre-built templates, in a manner similar to the Data Dictionary. Instructions for how to do so are also provided in the Technical Whitepaper on Data Model Document Generation, which details how to extract the data dictionary from ERwin section.