Table of Contents

Search

  1. Preface
  2. PowerExchange Navigator Introduction
  3. Data Maps
  4. Data Maps for Specific Data Sources
  5. Copybooks
  6. Registration Groups and Capture Registrations
  7. Extraction Groups and Extraction Maps
  8. Personal Metadata
  9. Database Row Test
  10. PowerExchange Navigator Examples
  11. Appendix A: PowerExchange Functions for User-Defined Fields
  12. Appendix B: User Access Method Programs
  13. Appendix C: Application Groups and Applications
  14. Appendix D: Data Map Properties
  15. Appendix E: Record, Field, and Table Properties
  16. Appendix F: DTL__CAPXTIMESTAMP Time Stamps
  17. Appendix G: Trace for Creating a Memory Map When Importing a COBOL Copybook

Navigator User Guide

Navigator User Guide

PowerExchange Navigator Examples Overview

PowerExchange Navigator Examples Overview

PowerExchange provides example data maps, copybooks, and data files that you can use to learn how to create data maps.
Additionally, PowerExchange provides the following types of example programs written in Assembler, C, and PL/I:
  • User access method programs, named
    uam*.*
  • Record-level exit programs, named
    urle*.*
  • Programs called by using the CallProg function, named
    ucpe*.*
Example header files and JCL are provided for these programs.
The example files are located in the examples subdirectory in the PowerExchange installation directory on Windows. For example:
C:\Informatica\PowerExchange
n
.
n
.
n
\examples\
In this section, you use the example files to create the following types of data maps:
  • Single-record data map
  • Single-record data map that contains arrays
  • Multiple-record data map with complex tables
  • Data map with an imported COBOL copybook
  • Data map with an imported COBOL copybook with REDEFINES statements
  • Data map with an imported PL/I copybook with multiple definitions for a field
  • Data map that normalizes a field defined as an array with multiple occurrences
  • Data map with user-defined fields that use the PowerExchange CallProg function to call a user exit program that returns the class type of a field in the data map record

0 COMMENTS

We’d like to hear from you!