38.5 Download Specifications

As detailed in the staging area section, the mapping from the Staging Data Model to use cases, called the Download Specification (My Oracle Support) provides an efficient way to manage the sourcing of data into the OFSDF 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 Oracle Financial Services Analytical Applications (OFSAA) Data Model Document Generation Release 8.1.x, which details how to extract the data dictionary from erwin section.