Table of Contents

Search

  1. Preface
  2. Introduction to Data Integration Hub
  3. Getting Started with Data Integration Hub
  4. Creating Topics
  5. Creating Publications
  6. Creating Subscriptions
  7. Appendix A: Glossary

Getting Started

Getting Started

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!