Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Paste or Import the SQL Statement to the Developer Tool

Paste or Import the SQL Statement to the Developer Tool

  1. Locate the SQL file that contains the SQL statement to import, or copy the entire statement to the clipboard.
  2. In the Developer tool, click
    File
    New
    Mapping from SQL Query
    The
    Generate Mapping or Logical Data Object from SQL Query
    dialog box opens.
  3. Import the query to the dialog box. Choose one of these methods:
    • Select
      Enter an SQL Query
      and paste the query from the clipboard to the editor.
    • Select
      Select an SQL File
      and browse to and select the file.
  4. Click
    Validate
    .
    Developer tool validates the SQL statement. Correct any errors.
  5. If you want to generate a logical data object instead of a mapping, select
    Generate Logical Data Object from the SQL Query
    .
    If you select this option, perform the following steps:
    1. Optionally rename the logical data object to create.
    2. Optionally click
      Browse
      to select a location for the Logical Data Object, or accept the default location.
    3. Click
      Validate
      .
      Developer tool validates the SQL statement. Correct any errors.
  6. Click
    Next
    .
    The
    Select the data source for the table
    dialog box opens.
  7. To select a data source for the table, click in the Data Source column, and then click
    Browse
    .
    The following image shows where to click
    Browse
    to select a data source:
  8. Click
    Finish
    .
The Developer tool generates a mapping from the SQL query and opens the mapping in an editor.

0 COMMENTS

We’d like to hear from you!