Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Comparing Objects
  12. Managing Business Components
  13. Creating Cubes and Dimensions
  14. Using the Mapping Wizards
  15. Appendix A: Datatype Reference

Designer Guide

Designer Guide

Importing Flat Files

Importing Flat Files

You can import fixed-width and delimited flat file definitions that do not contain binary data. When importing the definition, the file must be in a directory local to the client machine. In addition, the
CDI-PC Integration Service
must be able to access all source files during the session.
When you create a file source, target, or lookup definition, you must define the properties of the file. The Flat File Wizard prompts you for the following file properties:
  • File name and location
  • File code page
  • File type
  • Column names and datatypes
  • Number of header rows in the file
  • Column size and null characters for fixed-width files
  • Delimiter types, quote character, and escape character for delimited files

0 COMMENTS

We’d like to hear from you!