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

Microsoft SQL Server Function Exceptions

Microsoft SQL Server Function Exceptions

The Data Integration Service cannot push supported functions to Microsoft SQL Server sources under certain conditions.
The Data Integration Service processes transformation logic for Microsoft SQL Server sources when expressions contain supported functions with the following logic:
  • IN includes the CaseFlag argument.
  • INSTR includes more than three arguments.
  • LTRIM includes more than one argument.
  • RTRIM includes more than one argument.
  • TO_BIGINT includes more than one argument.
  • TO_INTEGER includes more than one argument.

0 COMMENTS

We’d like to hear from you!