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
  • Data Integration
  • All Products

Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

Back Next

SQL ELT query preview

SQL ELT query preview

When you create a mapping that is configured for SQL ELT optimization
or a mapping in SQL ELT mode
, you can preview the SQL queries that
Data Integration
 pushes to the database or cloud data warehouse. Preview these queries in the
SQL ELT Query
 panel in the Mapping Designer.
You can preview SQL ELT queries for some connector types. For more information, see the help for the appropriate connector.
When you preview SQL ELT queries,
Data Integration
 creates and runs a temporary SQL ELT preview mapping task. When the job completes,
Data Integration
 displays the SQL to be executed and any warnings in the
SQL ELT Query
 panel.
The following image shows the
SQL ELT Query
 panel:
The image shows the SQL ELT Query panel on the right side of the Mapping Designer. The panel shows that there are no warnings in the General Warnings area. Group 1 is expanded and shows the SQL query to be executed.
For mappings that are configured for SQL ELT optimization,
Data Integration
 groups SQL and warnings based on the data flow run order. After you run the SQL ELT preview job, you can preview the data after it's transformed by the transformations included in the SQL queries.
If the SQL ELT optimization type that you select isn't available,
Data Integration
 lists the SQL queries, if any, that can be executed. For example, if you select Full SQL ELT optimization, but the target doesn't support it,
Data Integration
 displays the SQL queries that will be pushed to the source.
You can't preview SQL ELT queries in advanced mode.
0 COMMENTS
We’d like to hear from you!