Table of Contents

Search

  1. Preface
  2. Getting Started Overview
  3. Part 1: Getting Started with Informatica Analyst
  4. Part 2: Getting Started with Informatica Developer

Profiling Getting Started Guide

Profiling Getting Started Guide

Task 1. Create the Flat File Data Object

Task 1. Create the Flat File Data Object

In this task, you use the
Add Flat File
wizard to create a flat file data objects from the LA_Customers data file.
  1. In the
    Projects
    Navigator, select the Customers folder in your tutorial project.
    You must select the project or folder where you want to create the flat file data object before you can create it.
  2. Click
    New
    Flat File Data Object
    .
    The
    Add Flat File
    wizard appears in the
    Discovery
    workspace.
  3. Select
    Browse and Upload
    , and click
    Browse
    .
  4. Browse to the location of LA_Customers.csv, and click
    Open
    .
  5. Click
    Next
    .
    The
    Choose type of import
    page displays
    Delimited
    and
    Fixed-width
    options. The default option is
    Delimited
    .
  6. Click
    Next
    .
  7. Under
    Specify the delimiters and text qualifiers used in the data
    , select
    Double quotes
    as a text qualifier.
  8. Under
    Specify lines to import
    , select
    Import from first line
    to import column names from the first line that is not empty.
  9. Click
    Next.
    The
    Column Attributes
    section shows the name, data type, precision, scale, and format for each column.
  10. Click
    Next
    .
    The
    Name
    field displays
    LA_Customers
    .
  11. Optionally, change the name of the file and add a description.
  12. In the
    Folders
    section, select the
    Customers
    folder.
  13. Click
    Finish
    .
    The LA_Customers data object appears in the
    Discovery
    workspace with the data preview of the source data.

0 COMMENTS

We’d like to hear from you!