ODI - Join and filter components

A join is a selector component that creates a join between multiple flows 

Implementation Steps:

Step1: Create physical and logical schemas in topology and context.

Step2: create models on logical schemas in design.

Step3: create a map and drag and drop jobs and job history tables as source in the default. Join them. And provide the join condition.

Step3: drag and drop target table and map them.

Join condition: job id from both source table.

Step4: add a filter on employee id on job history table 

Filter condition used as below.

Step5: Save and run and check operator tab and your target tables.