Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft Azure Synapse SQL Connector
  3. Connections for Microsoft Azure Synapse SQL
  4. Mappings for Microsoft Azure Synapse SQL
  5. Upgrading to Microsoft Azure Synapse SQL Connector
  6. Migrating a mapping
  7. SQL ELT optimization
  8. Data type reference
  9. Troubleshooting

Microsoft Azure Synapse SQL Connector

Microsoft Azure Synapse SQL Connector

Transformations with Microsoft Azure Synapse SQL

Transformations with Microsoft Azure Synapse SQL

When you configure
SQL ELT optimization
, Data Integration tries to push the configured transformation to Microsoft Azure Synapse SQL.
You can push the following transformations to Microsoft Azure Synapse SQL:
  • Aggregator
  • Expression
  • Filter
  • Joiner
  • Lookup
    *
  • Normalizer
    *
  • Rank
    *
  • Router
  • SQL
    *
  • Union
*Doesn't apply to mappings in advanced mode.

0 COMMENTS

We’d like to hear from you!