Setting up an Extract Hierarchy

Before starting create extracts and working extracts, have a clear plan of how they will be used. The user should maintain diagrams of the basic master / extract / working extract database organization. These help when devising flush and release procedures, and defining MDBs.

For project ttt:

Note: The databases shown are all part of the same extract family, and so they will all have the same database number as part of their filenames, for example ttt0200_0001.