English
  • PowerCenter 10.1.1
  • 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. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Designer Guide

Designer Guide

Back Next

Propagating Implicit Dependencies

Propagating Implicit Dependencies

You can propagate datatype, precision, scale, and description to ports with implicit dependencies. When you click Options in the Propagate Ports dialog box, you can choose to parse conditions and expressions to identify the implicit dependencies of the propagated port. All ports with implicit dependencies are output or input/output ports.
When you include conditions the Designer updates the following dependencies:
  • Link path dependencies
  • Output ports used in the same lookup condition as the propagated port
  • Associated ports in dynamic Lookup transformations that are associated with the propagated port
  • Output ports used by a Custom transformation to define a port relationship with one or more input or input/output ports
  • Master ports used in the same join condition as the detail port
When you include expressions, the Designer updates the following dependencies:
  • Link path dependencies
  • Output ports containing an expression that uses the propagated port
The Designer does not propagate to implicit dependencies within the same transformation. You must propagate the changed attributes from another transformation. For example, when you change the datatype of a port that is used in a lookup condition and propagate that change from the Lookup transformation, the Designer does not propagate the change to the other port dependent on the condition in the same Lookup transformation.