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. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Appendix A: Datatype Reference
  17. Appendix B: Configure the Web Browser

Designer Guide

Designer Guide

Selecting Code Pages

Selecting Code Pages

When you import a flat file in the Designer, you can select the code page of the file. The Designer lists the five code pages you have most recently selected. Then it lists all remaining code pages in alphabetical order.
The code page represents the code page of the
data
contained in the file. When you configure the file definition, specify delimiters, null characters, and escape characters that are supported by the code page.
For delimited files, specify delimiters, optional quotes, and escape characters that are contained in the source file code page. For fixed-width files, specify null characters as either a binary value from 0 to 255 or a character from the selected code page.
When you configure the flat file definition, use delimiters, escape characters, and null characters that are valid in the code page necessary to run a workflow.
  • ASCII data movement mode.
    Use characters from the code page you define for the flat file. Any 8-bit characters you specified in previous versions of PowerCenter are still valid.
  • Unicode data movement mode.
    Use characters from the code page you define for the flat file.

0 COMMENTS

We’d like to hear from you!