Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

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. Comparing Objects
  12. Managing Business Components
  13. Creating Cubes and Dimensions
  14. Using the Mapping Wizards
  15. Appendix A: Datatype Reference

Designer Guide

Designer Guide

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.

0 COMMENTS

We’d like to hear from you!