Procedure
- Drop tGreenplumConnection, tELTGreenplumInput (two), tELTGreenplumMap, tELTGreenplumOutput, tGreenplumCommit, tGreenplumInput and tLogRow from the Palette onto the workspace.
- Rename tGreenplumConnection as connect_to_greenplum_host, two tELTGreenplumInput components as employee+statecode and statecode, tELTGreenplumMap as match+map, tELTGreenplumOutput as map_data_output, tGreenplumCommit as commit_to_host, tGreenplumInput as read_map_output_table and tLogRow as show_map_data.
-
Link tGreenplumConnection to tELTGreenplumMap using an OnSubjobOk trigger.
Link tELTGreenplumMap to tGreenplumCommit using an OnSubjobOk trigger.Link tGreenplumCommit to tGreenplumInput using an OnSubjobOk trigger.
-
Link tGreenplumInput to tLogRow using a Row > Main
connection.
The two tELTGreenplumInput components and tELTGreenplumOutput will be linked to tELTGreenplumMap later once the relevant tables have been defined.