Scenario: Retrieving detailed dimension information from a given database - 6.3

Talend Open Studio for Big Data Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Open Studio for Big Data
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

The Job in this scenario retrieves details of all of the dimensions from a given database.

To replicate this scenario, proceed as follows:

Setting up the Job

  1. Drop tPaloDimensionList and tLogRow from the component Palette onto the design workspace.

  2. Right-click tPaloDimensionList to open the contextual menu.

  3. From this menu, select Row > Main to link the two components.

Configuring the tPaloDimensionList component

  1. Double-click the tPaloDimensionList component to open its Component view.

  2. In the Host name field, type in the host name or the IP address of the host server, localhost for this example.

  3. In the Server Port field, type in the listening port number of the Palo server. In this scenario, it is 7777.

  4. In the Username field and the Password field, type in the authentication information. In this example, both of them are admin.

  5. In the Database field, type in the database name where the dimensions of interest reside, Biker in this example.

Job execution

Press F6 to run the Job.

Details of all the dimensions in the Biker database are retrieved and listed in the console of the Run view.

For further information about the output schema, see Discovering the read-only output schema of tPaloDimensionList.