Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Rules and Guidelines for Creating Target Files by Transaction

Rules and Guidelines for Creating Target Files by Transaction

Use the following rules and guidelines when you create FileName columns:
  • You can use a FileName column with flat file targets.
  • You can add one FileName column to the flat file target definition.
  • You can use a FileName column with data from real-time sources.
  • A session fails if you use a FileName column with merge files, file lists, or FTP targets.
  • If you pass the same file name to targets in multiple partitions, you might get unexpected results.
  • When a transformation drops incoming transaction boundaries and does not generate commits, the Integration Service writes all rows into the same output file. The output file name is the initial value of the FileName port.


Updated June 25, 2018