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
  5. Appendix A: Frequently Asked Questions

Data Quality Getting Started Guide

Data Quality Getting Started Guide

Task 1. Create the Flat File Data Objects

Task 1. Create the Flat File Data Objects

In this task, you create a flat file data object from the LA_Customers file.
  1. In the Analyst tool, click
    New
    Flat File Data Object
    .
    The
    Add Flat File
    wizard appears.
  2. Select
    Browse and Upload
    , and click
    Browse
    .
  3. Browse to the location of LA_Customers.csv, and click
    Open
    .
  4. Click
    Next
    .
    The
    Choose type of import
    panel displays
    Delimited
    and
    Fixed-width
    options. Select the
    Delimited
    option. The default option is
    Delimited
    .
  5. Click
    Next
    .
  6. Under
    Specify the delimiters and text qualifiers used in your data
    , select
    Double quotes
    as a text qualifier.
  7. Under
    Specify lines to import
    , select
    Import from first line
    to import column names from the first nonblank line.
    The
    Preview
    panel updates to show the column headings from the first row.
  8. Click
    Next.
    The
    Column Attributes
    panel shows the datatype, precision, scale, and format for each column.
  9. Click
    Next
    .
    The
    Name
    field displays LA_Customers.
  10. Select the
    Tutorial_
    project and the
    Customers
    folder.
  11. Click
    Finish
    .
    The data object appears in the folder contents for the Customers folder.

0 COMMENTS

We’d like to hear from you!