Table of Contents

Search

  1. Preface
  2. Informatica Managed File Transfer Welcome Overview
  3. Dashboard
  4. Resources
  5. Workflows
  6. Task Reference
  7. Services Overview
  8. Users
  9. Logs and Reports
  10. Encryption
  11. System
  12. Appendix
  13. Glossary Terms

Example 1: Write Fixed-width File

Example 1: Write Fixed-width File

Follow the steps below to write a Fixed-width file. The input RowSet data being used in this example is based on the example data table in the RowSet topic.
  1. From within the Project Designer page, expand the Data Translation folder in the Component Library, and then drag the Write Fixed-width task to the Project Outline.
  2. On the Basic tab of the Write Fixed-width task, specify values for the following attributes:
    Input RowSet Variable
    The name of a variable of type RowSet which contains data to write to a file.
    Output File
    The file path and file name of a single file to write.
  3. On the Advanced tab of the Write Fixed-width task, specify the Include Column Headings value:
    Include Column Headings
    Whether or not to include column headings in the first row of the fixed-width file.
  4. Click the
    Add
    button in the sub-menu and select the Specify Data Options menu item.
  5. Click the
    Add
    button in the sub-menu and select the Add Column menu item.
  6. On the Basic tab of the Write Fixed-width Column element, specify the Index value:
    Index
    The index of the column in the input RowSet.
    Size
    Specify the size of this column. The default size is determined by the largest column in the first 50 columns in the RowSet. In this example, the largest column from the input RowSet is six characters. Therefore, the default column size for each column is six. A setting of 10 will be used to add empty spaces between the columns to make the output more easily readable.
  7. Repeat steps 5-6 to set the column size for each column in the RowSet.
  8. Click the
    Save
    button when finished.

0 COMMENTS

We’d like to hear from you!