Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Snowflake Function Exceptions

Snowflake Function Exceptions

Use the following rules and guidelines when pushing functions to Snowflake:
  • To push the TRUNC(DATE) or TO_CHAR() function to the Snowflake database, you must define the date and format arguments.
  • The Snowflake aggregate functions accept only one argument, which is a field set for the aggregate function. The PowerCenter Integration Service ignores any filter condition defined in the argument. Ensure that all fields mapped to the target are listed in the GROUP BY clause.
  • When you push the SYSTIMESTAMP() or SYSDATE() functions to the Snowflake database, do not specify any format. The Snowflake database returns the complete time stamp.
  • You cannot push the TO_BIGINT() or TO_INTEGER() function with more than one argument to the Snowflake database.
  • When you push the REPLACECHR() or REPLACESTR() function to the Snowflake database, the PowerCenter Integration Service ignores the caseFlag argument.
    For example, both REPLACECHR(false, in_F_CHAR, 'a', 'b') and REPLACECHR(true, in_F_CHAR, 'a', 'b') arguments return the same value.
  • You cannot use millisecond and microsecond values when you push functions to the Snowflake database.
  • You can use nanosecond values in the ADD_TO_DATE() and TRUNC(DATE) functions.
  • To push the TRUNC(DATE), GET_DATE_PART(), or DATE_DIFF() functions to the Snowflake database, you must use D, DDD, HH, MI, MM, SS, and YYYY time formats as arguments.
    For example,
    TRUNC(<datefieldname>, 'dd')
    .
    For information on date and time related functions, see the following website: https://docs.snowflake.net/manuals/sql-reference/functions-date-time.html#label-supported-date-time-parts

0 COMMENTS

We’d like to hear from you!