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

Rules and Guidelines for Flat Files

Rules and Guidelines for Flat Files

Consider the following rules and guidelines while working with flat files:
Upload small files to an Informatica services installation directory.
Upload files up to 10 MB to an Informatica services installation directory on the machine where the Analyst tool runs. The Analyst tool accesses this location to extract flat file metadata that does not change frequently. When you use files of sizes up to 10 MB, the Analyst tool accesses a copy of the file in the Informatica services installation directory. If you modify the original file, you need to upload the file again.
Upload large files to a network path location.
Enable the Analyst tool to connect to a network path location for files greater than 10 MB. The Analyst tool accesses this location to extract flat file metadata that changes frequently. The network path location should be a shared directory or file system that the Analyst tool can access. When you use files greater than 10 MB, the Analyst tool can connect to the flat file in the network path. If you modify the original flat file, you must refresh the flat file in the Analyst tool. Refreshing metadata for a large flat file can take time.
Blank data rows are not imported.
The Analyst tool does not import the blank rows above the first data row, blank middle rows, and blank rows after the last data row when importing a flat file.
Refresh the data preview.
After a preview, you can change the row number at which the
Add Flat File
wizard starts reading when it imports the file. This row number corresponds with the preview. If you choose to import column names from the first line, refresh the preview to update the row numbers for the preview data.

0 COMMENTS

We’d like to hear from you!