Generating Extraction Scripts

You can model operational and data warehouse data structures in PDMs, and specify mappings between the operational data sources and the data warehouse to generate extraction scripts to populate the data warehouse with operational data.

In this kind of relational-to-relational mapping, operational tables are mapped to data warehouse tables with a type of fact or dimension, and operational columns are mapped to warehouse columns.

You can generate a script file for each data source, you can also select the tables in the data source which select orders will be generated in the script file. The extraction scripts list all the select orders defined in the table mappings.

  1. In the Physical Diagram, select Database > Generate Extraction Script to open the Extraction Script Generation dialog box.


  2. Specify a destination directory for the generated file, and select the Check Model check box if you want to verify the PDM syntax before generation. The name of the script is identical to the name of the data source.
  3. [optional] Click the Options tab and specify any appropriate options. For more information, see Extraction Script Generation Options tab.
  4. [optional] Click the Selection tab, and select the tables that you want to use in the script generation.
  5. Click OK to generate the script files in the specified directory.