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. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Importing Flat Files without Shift Keys

Importing Flat Files without Shift Keys

Use the Flat File Wizard to import a fixed-width file source that does not contain shift keys. However, after you import the source definition, you must define shift states for each column in the file source definition so the Integration Service can read each character correctly.
You can also import shift-sensitive COBOL files that do not contain shift keys. When you do, you must also define the shift states for each column in the COBOL source definition.
When you create a session using a flat file source that contains user-defined shift states, verify that the code page in the Workflow Manager is the same as the code page you chose in the Designer. If you choose a different source code page in the Workflow Manager, the Integration Service does not use the shift keys you defined in the Designer.
To define shift states for fixed-width shift-sensitive files:
  1. In the Designer, import the flat file source or COBOL file.
  2. In the Source Analyzer, double-click the title bar of the file source definition.
  3. In the Flat File Information section of the Table tab, select Fixed Width and click Advanced.
    The Edit Flat File Information - Fixed Width Files dialog box appears.
  4. Select User Defined Shift State and click OK.
  5. Click the Columns tab.
    The Shift Key column appears.
  6. Choose a shift key for each column.
    Choose Shift-In if the column contains single-byte characters. Choose Shift-Out if the column contains multibyte characters.
  7. Click OK.


Updated June 25, 2018