Table of Contents

Search

  1. Introduction to Data Discovery
  2. Data Discovery with Informatica Analyst
  3. Data Discovery with Informatica Developer
  4. Function Support Based on Profiling Warehouse Connection

Data Discovery Guide

Data Discovery Guide

Creating DDL Scripts from an Enterprise Discovery Profile

Creating DDL Scripts from an Enterprise Discovery Profile

When you generate DDL script files from an enterprise discovery profile, you can choose the location where you want to save the script files. You can also choose the database type that you want to run the scripts against. Make sure that you verify and commit all the necessary changes in the enterprise discovery profile before you generate DDL scripts.
  1. In the
    Object Explorer
    view, select an enterprise discovery profile.
  2. Right-click the profile, and select
    Generate DDL
    .
    The
    Generate DDL
    dialog box appears.
  3. Click
    Browse
    to open the
    Save As
    dialog box.
    The default file extension is
    .sql
    .
  4. Choose a file location, and enter a file name.
  5. Select the type of target database.
  6. Click
    OK
    .
    The Developer tool generates the DDL script files in the location you specified.

0 COMMENTS

We’d like to hear from you!