Configuring the tPaloDimension component - 7.3
Palo
- Version
- 7.3
- Language
- English
- Product
- Talend Big Data
- Talend Big Data Platform
- Talend Data Fabric
- Talend Data Integration
- Talend Data Management Platform
- Talend Data Services Platform
- Talend ESB
- Talend MDM Platform
- Talend Real-Time Big Data Platform
- Module
- Talend Studio
- Content
- Data Governance > Third-party systems > Business Intelligence components > Palo components
- Data Quality and Preparation > Third-party systems > Business Intelligence components > Palo components
- Design and Development > Third-party systems > Business Intelligence components > Palo components
- Last publication date
- 2024-02-21
Procedure
-
On the workspace, double-click tPaloDimension to open its Component view.
-
Select the Use an existing connection
check box. Then tPaloConnection_1 displays
automatically in the Connection
configuration field.
-
In the Database field, type in the
database in which the new dimension is created,
talendDatabase for this scenario.
-
In the Dimension field, type in the name
you want to use for the dimension to be created, for example,
Date.
-
In the Action on dimension field, select
the action to be performed. In this scenario, select Create dimension if not exist.
-
Select the Create dimension elements
check box.
-
In the Consolidation Type area, select
the Normal check box.
-
Under the element hierarchy table in the Consolidation Type area, click the plus button to add three
rows into the table.
-
In the Input column column of the element
hierarchy table, select Year from the drop-down list
for the first row, Month for the second and
Date for the third. This determinates levels of
elements from different columns of the input schema.
