Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.
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 Connectors
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft SQL Server Connector
  3. Connections for Microsoft SQL Server
  4. Synchronization tasks with Microsoft SQL Server Connector
  5. Mappings and mapping tasks with Microsoft SQL Server Connector
  6. Replication tasks with Microsoft SQL Server
  7. Troubleshooting
  8. Data type reference

Microsoft SQL Server Connector

Microsoft SQL Server Connector

Back Next

Configuring cross-schema SQL ELT optimization

Configuring cross-schema
SQL ELT optimization

Consider the following steps to configure cross-schema
SQL ELT optimization
 for a Microsoft SQL Server
mapping
 task:
  1. Create the following two Microsoft SQL Server connections, each defined with a different schema:
    1. Create a
      sqlsv_1
       Microsoft SQL Server connection and specify
      CQA_SCHEMA1
       schema in the connection properties.
    2. Create a
      sqlsv_2
       Microsoft SQL Server connection and specify
      CQA_SCHEMA2
       schema in the connection properties.
  2. Create a Microsoft SQL Server mapping,
    m_sqlsv_pdo_acrossSchema
    . Perform the following tasks:
    1. Add a Source transformation and include a Microsoft SQL Server source object and connection
      sqlsv1
       to read data using
      CQA_SCHEMA1
      .
    2. Add a Target transformation and include a Microsoft SQL Server target object and connection
      sqlsv2
       to write data using
      CQA_SCHEMA2
      .
  3. Create a Microsoft SQL Server
    mapping
     task, and perform the following tasks:
    1. Select the configured Microsoft SQL Server mapping,
      m_sqlsv_pdo_acrossSchema
      .
    2. On the
      Runtime Options
       tab, in the
      SQL ELT Optimization
       section, set the p
      SQL ELT optimization
       value to
      Full
      .
    3. In the
      Advanced Session Properties
       section, select the
      Enable cross-schema SQL ELT optimization
       check box.
    4. Save the task and click
      Finish
      .
    When you run the
    mapping
     task, the Secure Agent reads data from the Microsoft SQL Server source object associated with the
    CQA_SCHEMA1
     schema and writes data to the Microsoft SQL Server target object associated with
    CQA_SCHEMA2
     schema.
0 COMMENTS
We’d like to hear from you!