Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Informatica Data Quality 10.4.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Getting Started with Informatica Analyst
  3. Lesson 1. Setting Up Informatica Analyst
  4. Lesson 2. Creating Data Objects
  5. Lesson 3: Creating a Mapping Specification

Mapping Specification Getting Started Guide

Mapping Specification Getting Started Guide

Back Next

Task 1. Create the Customers Flat File Data Object

Task 1. Create the Customers Flat File Data Object

In this task, you use the
Add Flat File
 wizard to create a flat file data object from Customers.csv.
  1. On the
    New
     header, click
    Flat File Data Object
    .
    The
    Add Flat File wizard
     appears.
  2. Select
    Browse and Upload
    , and click
    Choose File
     to browse to the location of Customers.csv.
  3. Accept the default
    Delimited
     option.
  4. Click
    Next
    .
  5. Under
    Specify lines to import
    , select
    Import from first line
     to import column names from the first non-blank line.
  6. Click
    Show
    .
    The details panel updates to show the column headings from the first row.
  7. Click
    Next
    .
    The
    Column Attributes
     panel shows the datatype, precision, scale, and format for each column.
  8. Edit the following column attributes:
    Column Name
    Datatype
    Precision
    Scale
    CHECKING_BALANCE
    Number
    38
    0
    SAVINGS_BALANCE
    Number
    38
    0
  9. Click
    Next
    .
  10. Select the Customers folder 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.
  11. Click
    Finish
    .
    The Analyst tool displays the data preview for the Customers flat file data object on the
    Data Preview
     tab. View the properties for the flat file on the
    Properties
     tab.
0 COMMENTS
We’d like to hear from you!