Scenario: Creating a cube in an existing database - 6.1

Talend Open Studio for Big Data Components Reference Guide

Talend Open Studio for Big Data
Data Governance
Data Quality and Preparation
Design and Development
Talend Studio

The Job in this scenario creates a new two dimensional cube in the Palo demo database Biker.

To replicate this scenario, proceed as follows:

Configuring the tPaloCube component

  1. Drop tPaloCube from the Palette onto the design workspace.

  2. Double-click tPaloCube to open its Component view.

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

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

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

  6. In the Database field, type in the database name in which you want to create the cube, Biker in this example.

  7. In the Cube field, type in the name you want to use for the cube to be created, for example, bikerTalend.

  8. In the Cube type field, select the Normal type from the drop-down list for the cube to be created, meaning this cube will be normal and default.

  9. In the Action on cube field, select the action to be performed. In this scenario, select Create cube.

  10. Under the Dimension list table, click the plus button twice to add two rows into the table.

  11. In the Dimension list table, type in the name for each newly added row to replace the default row name. In this scenario, type in Months for the first row and Products for the second. These two dimensions exist already in the Biker database where the new cube will be created.

Job execution

Press F6 to run the Job.

A new cube has been created in the Biker database and the two dimensions are added into this cube.