Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Mapping Outputs
  6. Generate a Mapping from an SQL Query
  7. Dynamic Mappings
  8. How to Develop and Run a Dynamic Mapping
  9. Dynamic Mapping Use Cases
  10. Mapping Administration
  11. Export to PowerCenter
  12. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Pushdown Optimization to ODBC Sources

Pushdown Optimization to ODBC Sources

The Data Integration Service can push transformation logic to databases that use database-specific ODBC drivers. If you select the ODBC provider as
Other
, the Data Integration Service cannot push transformation logic to the source.
When you use a database-specific ODBC driver to connect to a source, the Data Integration Service uses the native database SQL to generate SQL statements.
You can specify the ODBC provider in the ODBC connection object.
You can configure a specific ODBC provider for the following ODBC connection types:
  • Greenplum
  • Microsoft SQL Server
  • Netezza
  • SAP HANA
  • Sybase ASE
  • Teradata

0 COMMENTS

We’d like to hear from you!