Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Analyst
  3. Library Workspace
  4. Connections Workspace
  5. Job Status Workspace
  6. Projects Workspace
  7. Model Repository
  8. Data Objects
  9. Search
  10. Appendix A: Configure the Web Browser

Analyst Tool Guide

Analyst Tool Guide

Adding a Delimited Flat File

Adding a Delimited Flat File

When you import a flat file data object to a project or folder, you can set delimiters to format the data. You can change column attributes to match the data preview.
  1. On the
    New
    header, click
    Flat File Data Object
    .
    The
    Add Flat File wizard
    appears.
  2. Choose to browse for a location or enter a network path to import the flat file.
    • To browse for a location, select
      Browse and Upload
      and click
      Choose File
      to select the flat file from a directory that your machine can access.
    • To enter a network path, select
      Enter a Network Path
      and configure the path and file name of the file.
  3. Click
    Next
    .
  4. Accept the default
    Delimited
    option.
  5. Click
    Next
    .
  6. Configure the flat file options, and preview the flat file data.
    Select a code page that matches the code page of the data in the file.
  7. Optionally, click the
    Refresh
    icon in the
    Preview
    panel to update preview changes to the flat file data.
  8. Click
    Next
    .
  9. Optionally, change the
    Column Attribute
    .
  10. Click
    Next
    .
  11. Configure the name, optional description, and the location in the
    Folders
    panel where you want to add the flat file.
    The
    Flat Files
    panel displays the flat files that exist in a project or folder.
  12. Click
    Finish
    .
    The Analyst tool displays the properties for the flat file on the
    Properties
    tab. View the data preview for the flat file on the
    Data Preview
    tab.

0 COMMENTS

We’d like to hear from you!