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 an Empty Flat File Data Object

Creating an Empty Flat File Data Object

Create an empty flat file data object when you want to define the data object columns and rows in the Developer tool.
  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 as empty
    .
  5. Enter a name for the data object.
  6. Optionally, click
    Browse
    to select a project or folder for the data object.
  7. Click
    Next
    .
  8. Select a code page that matches the code page of the data that you want to process.
  9. Select
    Delimited
    or
    Fixed-width
    .
  10. If you selected
    Fixed-width
    , click
    Finish
    . If you selected
    Delimited
    , click
    Next
    .
  11. 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.
  12. Click
    Finish
    .
    The empty data object opens in the editor. Define the columns for the data object in the
    Overview
    view.

0 COMMENTS

We’d like to hear from you!