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. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Domain Object Export and Import
  12. License Management
  13. Monitoring
  14. Log Management
  15. Domain Reports
  16. Understanding Globalization
  17. Appendix A: Code Pages
  18. Appendix B: Custom Roles
  19. Appendix C: Informatica Platform Connectivity
  20. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

CDI-PC Source Code Page

CDI-PC
Source Code Page

The source code page depends on the type of source:
  • Flat files and VSAM files. The code page of the data in the file. When you configure the flat file or COBOL source definition, choose a code page that matches the code page of the data in the file.
  • XML files. The
    CDI-PC Integration Service
    converts XML to Unicode when it parses an XML source. When you create an XML source definition, the
    CDI-PC
    Designer assigns a default code page. You cannot change the code page.
  • Relational databases. The code page of the database client. When you configure the relational connection in the
    CDI-PC
    Workflow Manager, choose a code page that is compatible with the code page of the database client. If you set a database environment variable to specify the language for the database, ensure the code page for the connection is compatible with the language set for the variable. For example, if you set the NLS_LANG environment variable for an Oracle database, ensure that the code page of the Oracle connection is identical to the value set in the NLS_LANG variable. If you do not use compatible code pages, sessions may hang, data may become inconsistent, or you might receive a database error, such as:
    ORA-00911: Invalid character specified.
Regardless of the type of source, the source code page must be a subset of the code page of transformations and targets that receive data from the source. The source code page does not need to be a subset of transformations or targets that do not receive data from the source.
Select IBM EBCDIC as the source database connection code page only if you access EBCDIC data, such as data from a mainframe extract file.

0 COMMENTS

We’d like to hear from you!