-
Double-click tGreenplumConnection to open
its Basic settings view in the Component tab.
In the Host and Port fields, enter the context variables for the Greenplum
server.
In the Database field, enter the context
variable for the Greenplum database.
In the Username and Password fields, enter the context variables for the
authentication credentials.
For more information on context variables, see
Talend Studio User
Guide.
-
Double-click employee+statecode to open its
Basic settings view in the Component tab.
In the Default table name field, enter the
name of the source table, namely employee_by_statecode.
Click the [...] button next to the Edit schema field to open the schema editor.
Click the [+] button to add three columns,
namely id, name and
statecode, with the data type as INT4, VARCHAR,
and INT4 respectively.
Click OK to close the schema editor.
Link employee+statecode to tELTGreenplumMap using the output employee_by_statecode.
-
Double-click statecode to open its Basic settings view in the Component tab.
In the Default table name field, enter the
name of the lookup table, namely statecode.
-
Click the [...] button next to the Edit schema field to open the schema editor.
Click the [+] button to add two columns,
namely state and
statecode, with the data type as VARCHAR and INT4
respectively.
Click OK to close the schema editor.
Link statecode to tELTGreenplumMap using the output statecode.
-
Click tELTGreenplumMap to open its Basic settings view in the Component tab.
Select the Use an existing connection check
box.
-
Click the [...] button next to the ELT Greenplum Map Editor field to open the map
editor.
-
Click the [+] button on the upper left corner
to open the table selection box.
Select tables employee_by_statecode and
statecode in sequence and click Ok.
The tables appear on the left panel of the editor.
-
On the upper right corner, click the [+]
button to add an output table, namely employee_by_state.
Click Ok to close the map editor.
-
Double-click tELTGreenplumOutput to open its
Basic settings view in the Component tab.
In the Default table name field, enter the
name of the output table, namely employee_by_state.
-
Click the [...] button next to the Edit schema field to open the schema editor.
Click the [+] button to add three columns,
namely id, name and
state, with the data type as INT4, VARCHAR, and VARCHAR respectively.
Click OK to close the schema editor.
Link tELTGreenplumMap to tELTGreenplumOutput using the table output employee_by_state.
Click OK on the pop-up window below to
retrieve the schema of tELTGreenplumOutput.
Now the map editor's output table employee_by_state shares the same schema as that of tELTGreenplumOutput.
-
Double-click tELTGreenplumMap to open the map
editor.
Drop the column statecode from table
employee_by_statecode to its counterpart
of the table statecode, looking for the
records in the two tables that have the same statecode values.
Drop the columns id and name from table employee_by_statecode as well as the column statecode from table statecode to their counterparts in the output table employee_by_state.
Click Ok to close the map editor.
-
Double-click tGreenplumInput to open its
Basic settings view in the Component tab.
Select the Use an existing connection check
box.
In the Table name field, enter the name of
the source table, namely employee_by_state.
In the Query field, enter the query
statement, namely "SELECT * FROM \"employee_by_state\"".
-
Double-click tLogRow to open its Basic settings view in the Component tab.
In the Mode area, select Table (print values in cells of a table for a better
display.
In the Host and Port fields, enter the context variables for the Greenplum server.In the Database field, enter the context variable for the Greenplum database.In the Username and Password fields, enter the context variables for the authentication credentials.For more information on context variables, see Talend Studio User Guide.
In the Default table name field, enter the name of the source table, namely employee_by_statecode.Click the [...] button next to the Edit schema field to open the schema editor.
Click the [+] button to add three columns, namely id, name and statecode, with the data type as INT4, VARCHAR, and INT4 respectively.Click OK to close the schema editor.Link employee+statecode to tELTGreenplumMap using the output employee_by_statecode.
In the Default table name field, enter the name of the lookup table, namely statecode.
Click the [+] button to add two columns, namely state and statecode, with the data type as VARCHAR and INT4 respectively.Click OK to close the schema editor.Link statecode to tELTGreenplumMap using the output statecode.
Select the Use an existing connection check box.
Select tables employee_by_statecode and statecode in sequence and click Ok.The tables appear on the left panel of the editor.
In the Default table name field, enter the name of the output table, namely employee_by_state.
Click the [+] button to add three columns, namely id, name and state, with the data type as INT4, VARCHAR, and VARCHAR respectively.Click OK to close the schema editor.Link tELTGreenplumMap to tELTGreenplumOutput using the table output employee_by_state.Click OK on the pop-up window below to retrieve the schema of tELTGreenplumOutput.
Now the map editor's output table employee_by_state shares the same schema as that of tELTGreenplumOutput.
Select the Use an existing connection check box.In the Table name field, enter the name of the source table, namely employee_by_state.In the Query field, enter the query statement, namely
In the Mode area, select Table (print values in cells of a table for a better display.