English
  • PowerCenter 10.2 HotFix 2
  • 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. Datatype Reference
  17. Configure the Web Browser

Designer Guide

Designer Guide

Back Next

Example

Example

In the following mapping, the QTY port in the Joiner transformation links to the QTY port in the Aggregator transformation. The Aggregator transformation references the QTY port in the expressions for TOTAL_QUANTITY and TOTAL_REVENUE:
The mapping includes two sources called orders and products. The Source Qualifier transformations connect to the Joiner transformation. The Joiner transformation connects to the Aggregator transformation.
You make the following changes to the QTY port in the Joiner transformation:
  • You change the port name QTY to QUANTITY.
  • You change the datatype from Decimal to Integer.
When you propagate forward the attributes, the Designer updates the following dependencies in the Aggregator transformation:
  • The Designer updates QTY port name to QUANTITY.
  • The Designer updates the reference to QTY port name in the expressions for the TOTAL_QUANTITY and TOTAL_REVENUE ports change to QUANTITY.
  • The Designer updates the datatype of QTY port name to Integer.