Generating Data Warehouse 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 Scripts:


  2. Specify a destination directory for the generated file, and select the Check Model option if you want to verify the PDM syntax before generation.
  3. [optional] Click the Options tab and specify any appropriate options:

    Option

    Description

    Title

    Specifies to insert the database header and the name of the tables before each select query.

    Encoding

    Specifies the encoding format. You should select the format that supports the language used in your model and the database encoding format.

    Character Case

    Specifies the case to use in the generated file.

    No Accent

    Specifies to remove any accents from generated characters.

  4. [optional] Click the Selection tab, and select the tables for which you want to generate extraction scripts.
  5. Click OK to generate the script files in the specified directory. The name of the script is identical to the name of the data source.