Persisting

Overview

Persisting, shown by the PP marker, represents the storage of a transformation result in a managed persisted table. It shows which blue Transformation object provides the result and which table stores it.

Function

A persisting flow connects a blue Core-layer Transformation, such as DWH.DIM_Invoices, to a persisted result, such as DWH.DIM_Invoices_T. The predecessor Transformation provides the Add command used to create the persisting flow.

PP

 

The PP marker identifies the persisting relationship between the Transformation and its persisted result. Use the blue Transformation rectangle for Add -> Persisting. Do not use the persisted target as the predecessor creation object.

Access

Persisting can be created from an eligible blue Transformation object on the dataflow diagram. Existing persisting definitions can also be maintained from the package navigation tree.

How to access

Navigation tree

Packages -> Persisting -> package or persisting entry

Toolbar

There is no direct toolbar command for the PP relationship.

Create on diagram

Right-click a blue Transformation object and select Add -> Persisting.

Visual element

Blue Transformation with T marker -> PP marker -> persisted result table.

Screen overview

Persisting relationship screen overview

Context menu used to create a persisting

Right-click the predecessor blue Transformation object, not only the T or PP marker, and select Add -> Persisting.

Transformation context menu used to create a persisting

ID Command Description
1 Locate in tree Locates the selected transformation in the navigation tree.
2 Set filter Sets the selected transformation as the current filter for the dataflow diagram.
3 Add to filter Adds the selected transformation to the current diagram filter.
4 Refresh Refreshes the selected transformation in the dataflow diagram.
5 Add Opens the submenu containing the available options for adding a related object.
6 Duplicate Duplicates the selected transformation.
7 Delete Deletes the selected transformation.
8 References Opens the submenu containing reference-related options for the selected transformation.
9 Locks Opens the submenu containing lock-related options for the selected transformation.
10 Object groups Opens options for managing the object groups associated with the selected transformation.
11 Import/Export object definition Opens the submenu for exporting the selected transformation definition.
12 Customize colors Opens the submenu for customizing the display colors of the selected transformation.

Sub menus

Transformation submenu groups used for persisting

ID Submenu group Description
A Add Contains the available options for adding an object related to the selected transformation.
B References Contains options for viewing or managing references associated with the selected transformation.
C Locks Contains lock-related options for the selected transformation.
D Import/Export object definition Contains options for exporting the definition of the selected transformation.
E Customize colors Contains options for customizing the colors used to display the selected transformation.

A) Add Submenu

Transformation Add submenu used on the Persisting page

ID Command Description
1 Data source Opens options for adding a data source.
2 Import Opens options for adding an import object.
3 Historization Opens options for adding a historization object.
4 Persisting Opens options for adding a persisting object.
5 Transformation Opens options for adding a transformation object.
6 Export Opens options for adding an export object.
7 Data vault hub Opens options for adding a Data vault hub.
8 Data vault satellite Opens options for adding a Data vault satellite.
9 Data vault link Opens options for adding a Data vault link.
10 Calendar dimension Opens options for adding a calendar dimension.
11 Time dimension Opens options for adding a time dimension.
12 Snapshot dimension Opens options for adding a snapshot dimension.

B) References Submenu

Transformation References submenu used on the Persisting page

ID Command Description
1 Show reference diagram (active) Shows active reference diagrams associated with the selected transformation.
2 Show reference diagram (inactive) Shows inactive reference diagrams associated with the selected transformation.
3 Show reference diagram (all) Shows all reference diagrams associated with the selected transformation.
4 List references Lists references associated with the selected transformation.
5 Add reference Adds a reference to the selected transformation.
6 Start reference Starts creating a reference from the selected transformation.

C) Locks Submenu

Transformation Locks submenu used on the Persisting page

ID Command Description
1 Lock object Locks the selected transformation.

D) Import/Export object definition Submenu

Transformation Import/Export object definition submenu used on the Persisting page

ID Command Description
1 Export to file Exports the selected transformation definition to a file.
2 Export to cloud Exports the selected transformation definition to the cloud.

E) Customize colors Submenu

Transformation Customize colors submenu used on the Persisting page

ID Command Description
1 Background Color Changes the background color of the selected transformation.
2 Foreground Color Changes the foreground color of the selected transformation.

Related topics