English
  • PowerCenter 10.5
  • All Products

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

Back Next

Working with Sources Overview

Working with Sources Overview

To extract data from a source, first define sources in the repository. You can import or create the following types of source definitions in the Source Analyzer:
  • Relational tables, views, and synonyms
  • Fixed-width and delimited flat files that do not contain binary data.
  • COBOL files
  • XML files
  • Web Services Description Language (WSDL)
  • Data models using certain data modeling tools through Metadata Exchange for Data Models (an add-on product)
You can import sources that use multibyte character sets. Source code pages must be a superset of the target code pages.
Source definitions can be single- or multi-group. A single-group source has a single group in the source definition. Relational sources use a single-group source definition. A multi-group source has multiple groups in the source definition. Non-relational sources such as XML sources use multi-group source definitions.
Because source definitions must match the source, you should import definitions instead of creating them manually.