Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Object Import and Export
  12. Data Type Reference
  13. Keyboard Shortcuts
  14. Connection Properties

Developer Tool Guide

Developer Tool Guide

Flat File Data Objects Overview

Flat File Data Objects Overview

Create a flat file physical data object to include in a mapping, mapplet, or profile. You can add flat file data objects to mappings and mapplets as Read, Write, and Lookup transformations. You can create and run a profile on flat file data objects.
A flat file data object can be delimited or fixed-width. You can create flat file data objects from fixed-width and delimited flat files that do not contain binary data.
You can configure a flat file data object to handle the changes in the flat file data source at run time. You can also generate column names for the flat file data object by using the information from the flat file or from the control file. The control file contains information on the column name, precision, scale, and the number of bytes to process.
After you create a flat file data object, use the following views to configure flat file properties:
Overview view
Configure the flat file data object name and description and update column properties.
Parameters view
Create parameters for the flat file data object.
Advanced view
Configure the format and run-time properties that the Data Integration Service uses when it reads data from and writes data to the flat file.
When you add flat file data objects to mappings as Read or Write transformations, you can view the format and run-time properties for the flat file data object in the
Properties
view. You cannot edit the flat file properties within a mapping.

0 COMMENTS

We’d like to hear from you!