Table of Contents

Search

  1. Version 10.2.2
  2. Version 10.2.1
  3. Version 10.2
  4. Version 10.1.1
  5. Version 10.1

Release Guide

Release Guide

Generate a Mapping or Logical Data Object from an SQL Query

Generate a Mapping or Logical Data Object from an SQL Query

Effective in version 10.1, you can generate a mapping or a logical data object from an SQL query in the Developer tool.
To generate a mapping or logical data object from an SQL query, click FileNewMapping from SQL Query. Enter a SQL query or select the location of the text file with an SQL query that you want to convert to a mapping. You can also generate a logical data object from an SQL query that contains only SELECT statements.
For more information about generating a mapping or a logical data object from an SQL query, see the Informatica 10.1 Developer Mapping Guide.


Updated December 18, 2019