Mapping data using a simple implicit join
Last updated: 8/27/2026In this scenario, a tELTGreenplumMap component is deployed to retrieve the data from the source table employee_by_statecode, compares its statecode column against the table statecode, and then maps the desired columns from the two tables to the output table employee_by_state.
Before the Job execution, the three tables, employee_by_statecode, statecode and employee_by_state look like: