Table of Contents

Search

  1. Preface
  2. Introduction to Amazon S3 V2 Connector
  3. Connections for Amazon S3 V2
  4. Amazon S3 V2 sources and targets
  5. Mappings and mapping tasks with Amazon S3 V2
  6. Migrating a mapping
  7. Upgrading to Amazon S3 V2 Connector
  8. Data type reference
  9. Troubleshooting

Amazon S3 V2 Connector

Amazon S3 V2 Connector

Parameterization using timestamp

Parameterization using timestamp

You can append time stamp information to the file name to show when the file is created. You can use parameterization using timestamp when you create a mapping to write a file of flat format type.
You cannot parameterize using timestamp in mappings in advanced mode.
When you specify a file name for the target file, include special characters based on Apache
STRFTIME
function formats that the
mapping
task uses to include time stamp information in the file name. You must enable
Handle Special Characters
options to handle any special characters in the
%[mod]
format included in the file name. You can use the
STRFTIME
function formats in a mapping.
If you enable
Handle Special Characters
, the Secure Agent ignores the input and output parameters in
Create Target
.
The following table describes some common
STRFTIME
function formats that you might use in a mapping or
mapping
task:
Special Character
Description
%d
Day as a two-decimal number, with a range of 01-31.
%m
Month as a two-decimal number, with a range of 01-12.
%y
Year as a two-decimal number without the century, with range of 00-99.
%Y
Year including the century, for example 2015.
%T
Time in 24-hour notation, equivalent to %H:%:M:%S.
%H
Hour in 24-hour clock notation, with a range of 00-24.
%l
Hour in 12-hour clock notation, with a range of 01-12.
%M
Minute as a decimal, with a range of 00-59.
%S
Second as a decimal, with a range of 00-60.
%p
Either AM or PM.

0 COMMENTS

We’d like to hear from you!