Generating a Netezza DDL from CA ERwin

From the physical data model of the Atomic Warehouse Model (AWM) or the Dimensional Warehouse Model (DWM), you can generate a Netezza–compatible DDL using a Microsoft PowerShell script available with the product.

Before you begin

Transform AWM or DWM into a physical data model as described in Transforming to physical with CA ERwin.

Procedure

  1. Locate the generate_xml_to_ddl.ps1 script in the installation directory.
  2. Refer to the readme.txt file for more details on running this script.
  3. Start Microsoft PowerShell.
  4. Run ./generate_xml_to_ddl.ps1 <path_to_xml_file> <target_ddl_file> <char_delim> <distrib_key> <max_length>. For example, ./generate_xml_to_ddl.ps1 ‘c:\physmodel.xml’ ‘myDDL.sql’ ‘;’ ‘PK’ ‘255’.

Results

This creates Netezza-compatible DDL files.