Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Common Content for Data Engineering 10.4.0
  • All Products

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

Back Next

Generating a Mapping or Logical Data Object from an SQL Query

Generating a Mapping or Logical Data Object from an SQL Query

You can convert an SQL statement into a mapping or a logical data object. You might want to generate a logical data object to create an object that you can reuse in other mappings.
  1. Click
    File
    New
    Mapping from SQL Query
    .
    The
    Generate Mapping or Logical Data Object from SQL Query
     dialog box opens.
  2. Choose whether to enter an SQL query, or select a file that contains an SQL query.
    • To enter an editable SQL query, choose
      Enter an SQL Query
      , and then type or paste an SQL query in the editor. Then click
      Validate Query
      .
    • To select a file that contains an SQL query, choose
      Select an SQL file
      , and then browse to the file that contains an SQL query.
    The Developer tool validates the SQL syntax. If the syntax is not valid, you must fix it before you can proceed.
  3. To generate a logical data object instead of a mapping, select
    Generate Mapping as a Logical Data Object
    .
  4. Optionally, rename the mapping or logical data object that you want to generate.
  5. Click
    Next
    .
    The dialog box displays the tables that correspond to data sources.
  6. Click the row of the table under
    Data Source
     to select the data source for the mapping.
    If the table has a data source, you can click it to optionally change the data source.
    The
    Select Data Source
     dialog box opens and lists the tables on the Model repository that you can access.
  7. Select any data source in the Model repository.
  8. Click
    Finish
    .
The generated mapping or logical data object opens in an editor.
You can select any object in the mapping to view or edit it. Then you can run the mapping or include it in an application or workflow that you deploy to the Data Integration Service.
If you created a logical data object, you can reuse it in other mappings. For example, you can reuse the generated logical data object as the source in a mapping.
0 COMMENTS
We’d like to hear from you!