Tuesday, August 4, 2015

How to generate target file names dynamically from the mapping with timestamps

How to generate target file names dynamically from the mapping with timestamps


When you want to create the file name with a timestamp attached to it, just use a port from an Expression transformation before the target to pass a value of Output Port with expression $$FILE_NAMEto_char(sessstarttime, 'YYYYMMDDHH24:MISS')'.csv'.










No comments:

Post a Comment

SNOWFLAKE Interview Questions 2025

  1️ ⃣ Choosing the Perfect Size of Virtual Warehouse To select the right size (X-Small to 6X-Large), consider: Data Volume ...