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.5
- 10.5.6
- 10.5.4
- 10.4.0

Back Next

Generate a Mapping from an SQL Query Overview

You can generate a mapping from an SQL query in the Developer tool. To generate a mapping, you can enter an SQL query or you can load a text file that contains the query. Optionally, you can define the source of the query table. The Developer tool validates the SQL query and generates a mapping.

You can also generate a logical data object from an SQL query that contains only SELECT statements.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Generate a Mapping from an SQL Query Overview

Generate a Mapping from an SQL Query Overview