Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Object Import and Export
  12. Data Type Reference
  13. Keyboard Shortcuts
  14. Connection Properties

Developer Tool Guide

Developer Tool Guide

Creating a Flat File Data Object from a Control File

Creating a Flat File Data Object from a Control File

Create a flat file data object from a control file when you want to define the data object columns and rows based on a control file.
  1. Select a project or folder in the
    Object Explorer
    view.
  2. Click
    File
    New
    Data Object
    .
  3. Select
    Physical Data Objects
    Flat File Data Object
    and click
    Next
    .
    The
    New Flat File Data Object
    dialog box appears.
  4. Select
    Create from a control file
    .
  5. Click
    Browse
    and navigate to the directory that contains the control file.
  6. Click
    Open
    .
    The wizard names the data object the same name as the control file you selected.
  7. Optionally, edit the data object name.
  8. Optionally, click
    Browse
    to select a project or folder for the data object.
  9. Click
    Next
    .
  10. Select a code page that matches the code page of the data that you want to process.
  11. Select
    Delimited
    or
    Fixed-width
    .
  12. If you selected
    Fixed-width
    , click
    Finish
    . If you selected
    Delimited
    , click
    Next
    .
  13. Configure the following delimited format properties:
    Property
    Description
    Delimiters
    Character used to separate columns of data. If you enter a delimiter that is the same as the escape character or the text qualifier, you might receive unexpected results.
    Text Qualifier
    Quote character that defines the boundaries of text strings. If you select a quote character, the Developer tool ignores delimiters within a pair of quotes.
  14. Click
    Finish
    .
    The data object opens in the editor.

0 COMMENTS

We’d like to hear from you!