Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

Lineage for fields containing expressions

Lineage for fields containing expressions

You can view the lineage for expression fields, aggregate fields, and for advanced filters that contain incoming fields.
When the expression contains incoming fields, the upstream lineage includes the fields used in the expression.
For example, you configure the expression field Full_Name to concatenate the Firstname and Lastname source fields before loading the data to the target. When you view the field lineage of the expression field Full_Name, the upstream lineage includes the Firstname and Lastname fields.
If the expression doesn't contain incoming fields, the lineage includes only downstream transformations. Lineage also doesn't include variable fields used in the expression.
You can view the upstream field lineage for an advanced filter condition if the expression contains one or more incoming fields. Data Integration doesn't include the downstream lineage because Filter transformations do not include output fields. If you want to view the full lineage for a field included in a filter condition, view the lineage from an upstream or downstream transformation.

0 COMMENTS

We’d like to hear from you!