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
  • PowerCenter 10.4.0
  • All Products

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

Back Next

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!