Recommendations and Scripts provide rich technical details and tips about the components, usage, and performance of dataflows.
The dataflow must be saved before Recommendations can be accessed. Even if only one entity has been added to the canvas, the dataflow must be saved to access helpful design tips. For example, when JDBC entities are discovered at the same time, relations between fields are identified and retained for Primary Keys (PK) and Foreign Keys (FK). This information is leveraged in the metadata to assist users to build dataflows.
Recommendations: Common Usage tab details how the same entities have been used in other dataflows.
Recommendations: Design Tips provide options and directions for dataflow design. For example, for a JDBC entity that was discovered with other entities, design tips may provide primary and foreign keys that help for designing joins. Suggestions are provided for building dataflows such as join conditions, filter and router options, transform ranges and trimming options.
Recommendations: Performance Tips tab details how users can optimize performance for dataflow executions