CLAIRE might recommend additional source objects when the Source transformation in a mapping uses an Amazon Redshift, Oracle, or Snowflake connection.
To receive CLAIRE recommendations for source objects belonging to a connection, the connection needs to be scanned for metadata and data. For more information about metadata extraction and data profiling using Metadata Command Center, see the Metadata Command Center help.
Note: The schema name in the connection properties must match the schema name used in the database, including any capitalization.
CLAIRE makes recommendations for additional source objects based on primary key and foreign key relationships. The recommendations can be helpful when you want to use multiple source objects and you have many tables on the data source to search through.
For example, you want to find a list of customers together with the type of car each customer has ordered. For the Source transformation in your mapping, you use a connection to an Oracle database that contains hundreds of tables. You select a customer table for the source object. In the CLAIRE Recommendations tab, CLAIRE suggests several tables that can be joined to the customer table. One of the tables contains customer order data. You add the table to the mapping as an additional Source transformation.
When a recommendation is available, Data Integration highlights the Recommendations tab. Select the Recommendations tab to see the recommendations.
In the list of recommendations, click the Show Me icon for the source that you want to investigate. A Source transformation with the recommended source object appears on the mapping canvas. The following image shows the Show Me icon for a recommended source:
Open the Source transformation and click the Fields tab to review the source fields in the source object.
If you want to use the source, in the Recommendations tab, click the Accept icon. In the mapping canvas, connect the Source transformation to the data flow.
If you don't want to use the recommended source, click Decline. Data Integration removes the recommended Source transformation from the mapping canvas.
Note: Source recommendations aren't shown for ORC file sources, since Data Governance and Catalog doesn't support this format.
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.
Union recommendations
When CLAIRE recommends an additional source object, it might also recommend a Union transformation if it detects a union relationship between the two sources. If you accept the recommendation, Data Integration automatically unions the sources.
By default, Data Integration adds the original source as Input Group 1 and maps the original source fields to the Union transformation output fields.
To review the recommended source and Union transformation, in the Recommendations tab, select Show with Union for the source that you want to review, and then click the Show Me icon. If you want to use the source with the Union transformation, in the Recommendations tab, click the Accept icon. In the mapping canvas, connect the Union transformation to the data flow.
