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

Join recommendations

Join recommendations

When CLAIRE recommends an additional source object, it might also recommend joining the new source and the original source with a Joiner transformation if it detects a join relationship between the two objects.
Data Integration
automatically joins the sources with a normal join based on the recommended join condition. By default, when
Data Integration
joins the sources, it links the recommended source to the Master group and the original source to the Detail group. To avoid field name conflicts,
Data Integration
prefixes field names in the recommended source.
To review the recommended join condition, in the
Recommendations
tab, select
Show with Joiner
for the source that you want to review, and then click the
Show Me
icon. In the mapping canvas, open the Joiner transformation and click the
Join Condition
tab.
If you want to use the source with the Joiner transformation, in the
Recommendations
tab, click the
Accept
icon. In the mapping canvas, connect the Joiner transformation to the data flow.

0 COMMENTS

We’d like to hear from you!