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

Viewing Source Column Dependencies

Viewing Source Column Dependencies

When editing a mapping, you can view source column dependencies for a target column. Viewing source column dependencies lets you see from which source columns a target column receives data.
To view column dependencies, right-click a target column in a mapping and choose Show Field Dependencies. The Designer displays the Field Dependencies dialog box which lists all source columns connected to the target column.
When you define a port expression that performs a calculation using multiple source columns, and then connect that port to a target column, the Field Dependencies dialog box lists all source columns you use in the expression.
For example, you have the following mapping:
The mapping includes a source, Source Qualifier transformation, Aggregator transformation, and target.
Define the following expression in the Q3_sales port in the Aggregator transformation:
LAST(sales, quarter = 3)
Right-click the Q3_sales target column and choose Show Dependencies.
The following figure shows the Field Dependencies dialog box that appears:
Quarter and sales fields are listed beneath store_sales_detail.


Updated June 25, 2018