Table of Contents

Search

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

Developer Mapping Guide

Developer Mapping Guide

Amazon Redshift Function Exceptions

Amazon Redshift Function Exceptions

The Data Integration Service cannot push supported functions to Amazon Redshift databases under certain conditions.
  • To use pushdown optimization, you must set the value of the
    Multiple Matches
    Lookup transformation property to
    Return all rows
    .
  • To push TRUNC(DATE) to Amazon Redshift, you must define the date and format arguments. Otherwise, the agent does not push the function to Amazon Redshift.
  • The aggregator functions for Amazon Redshift accept only one argument, a field set for the aggregator function. The filter condition argument is ignored. In addition, verify that all fields mapped to the target are listed in the GROUP BY clause.
  • To push TO_DATE() to Amazon Redshift, you must define the string and format arguments.
  • To push TO_CHAR() to Amazon Redshift, you must define the date and format arguments.
  • Do not specify a format for SYSTIMESTAMP() to push the SYSTIMESTAMP to Amazon Redshift. The Amazon Redshift database returns the complete time stamp.
  • To push INSTR() to Amazon Redshift, you must only define string, search_value, and start arguments. Amazon Redshift does not support occurrence and comparison_type arguments.
  • The flag argument is ignored when you push TO_BIGINT and TO_INTEGER to Amazon Redshift.
  • The CaseFlag argument is ignored when you push IN() to Amazon Redshift.
  • If you use the NS format as part of the ADD_TO_DATE() function, the agent does not push the function to Amazon Redshift.
  • If you use any of the following formats as part of the TO_CHAR() and TO_DATE() functions, the agent does not push the function to Amazon Redshift:
    • NS
    • SSSS
    • SSSSS
    • RR
  • To push TRUNC(DATE), GET_DATE_PART(), and DATE_DIFF() to Amazon Redshift, you must use the following formats:
    • D
    • DDD
    • HH24
    • MI
    • MM
    • MS
    • SS
    • US
    • YYYY

0 COMMENTS

We’d like to hear from you!