Table of Contents

Search

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

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
File
New
Mapping 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 July 25, 2019