Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: PowerExchange Client for PowerCenter (PWXPC)
  4. Part 3: PowerExchange ODBC
  5. Appendix A: PowerExchange Interfaces for PowerCenter Tips
  6. Appendix B: Datatypes and Code Pages
  7. Appendix C: PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Working with Mappings for PowerExchange ODBC Overview

Working with Mappings for PowerExchange ODBC Overview

A mapping is a set of source and target definitions linked by transformation objects that define the rules for data transformation. Mappings represent the data flow between sources and targets.
Source and target definitions represent metadata for sources and targets. When you create a source definition, its structure differs depending on the type of source it represents:
  • Nonrelational sources require a multi-group source definition.
  • Relational sources use a single-group source definition.
The source qualifier for a source definition also differs in structure depending on the type of source definition.
After you create a source or target definition, you can include it in a mapping to extract data from the source or load data to the target. You can extract source data in batch, change, or real-time mode. You can use one source definition and one mapping for all modes.

0 COMMENTS

We’d like to hear from you!