Preface
Mappings
Mapplets
Mapping Parameters
Where to Assign Parameters
Mapping Outputs
Generate a Mapping from an SQL Query
Dynamic Mappings
How to Develop and Run a Dynamic Mapping
Dynamic Mapping Use Cases
- Use Case: Dynamic Mapping for Metadata Changes in Relational Sources
- Use Case: Reuse Dynamic Mapping for Different Sources and Targets
Mapping Administration
Export to PowerCenter
Import From PowerCenter
Performance Tuning
Pushdown Optimization
Partitioned Mappings
Developer Tool Naming Conventions

Developer Mapping Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5

Back Next

SQL Syntax to Generate a Mapping

You can use an ANSI-compliant SQL statement to generate a mapping in the Developer tool.

The Developer tool can generate a mapping from a standard SELECT query. For example:

SELECT column_list FROM table-name 
[WHERE clause]
[GROUP BY clause]
[HAVING clause]
[ORDER BY clause]

If the SELECT SQL statement contains a correlated subquery, the query is valid if it is possible to flatten or rewrite the query as a single standard query.

ANSI SQL does not support some datatypes. For example, if the query requests results from a data source where one of the columns has the type timeStampTZ, the SQL is not valid.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

SQL Syntax to Generate a Mapping

SQL Syntax to Generate a Mapping