Table of Contents

Search

  1. Preface
  2. Introduction to Data Integration Hub
  3. Catalog
  4. Applications
  5. Topics
  6. Creating Topics
  7. Topic Properties
  8. Publications
  9. Creating Publications
  10. Publication Properties
  11. Subscriptions
  12. Creating Subscriptions
  13. Subscription Properties
  14. Events and Event Monitoring
  15. Dashboard and Reports
  16. Glossary

Operator Guide

Operator Guide

Target File Name Pattern for Flat Files

Target File Name Pattern for Flat Files

When you define a flat file target, the pattern of the file name, which you define in the
Target Filename Pattern
field, can contain the following variables:
Variable
Description
($Table_Name)
Name of the table in the topic that contains the data. Use this variable in topics that include more than one table to create an output file for each table column.
($Time_Stamp)
Date and time when the subscription runs, in the following format:
yyyy-mm-dd-hh24_mi_ss
($Publication_Instance_Date)
Date and time when the publication instance is created, in the following format:
yyyy-mm-dd-hh24_mi_ss
Use this variable to differentiate between multiple publication instances and to sort publications by date.
For example, the file name pattern
file_($Table_Name)_($Publication_Instance_Date).txt
creates the following file name:
file_ORDERS_2015-03-27-12_43_26.txt

0 COMMENTS

We’d like to hear from you!