Operations

Introduction

The processing of a DTP activity may involve one or several operations, which the system runs in sequence. Every operation is the child of an activity and acts on a single dataset which is mandatorily indicated on the associated activity. Every operation performs calculations on a type of data in the target dataset associated with the activity. In the operation configurations, the operation can be subordinated to a certain SQL condition.

Operation types:

IMPORTANT: once an operation has been created, its type cannot be changed.

Operation type	Description
Insertion	Allows you to add records to a dataset. Data the source of which is other datasets, datasources, reference tables etc. can be used as the source. For details on insertion operations, see: - Insert with reference dataset - Insert from other dataset - Insert with calculation rule - Insert with pivot transposition - Insert with unpivot transposition
Loading	Allows you to define one or several fields of a target dataset on an Analytical Workspace based on another source. For details on the loading operation, see: - Loading to Analytical Workspace
Enrichment	This allows you to update or define dataset columns that have already been defined. Other datasets, datasources, reference tables, SQL formulas, etc. can be used as sources. For details of enrichment operations, see: - Enrichment from another dataset - Enrichment with Reference dataset - Enrichment with formula - Enrichment with formula field - Enrichment with ranking - Join from another dataset
Allocation	Allows you to run an analytical allocation on a dataset using another dataset as the driver. For details on allocation operations, see: - Allocations
Check	Allows you to run validity checks on the records present in a dataset. There are several types of check, e.g. check with formula, check with dictionary. For details of checking operations, see: - Check with formula - Check with dictionary - Check with rule - Check missing keys - Existence check - Check multiple keys When a DTP is run from the contributor's cockpit and a lowest level element is selected, if the launch is of the standard type (not context-independent) and contains control operations that have encountered anomalies during execution, the DTP Report can be displayed. See DTP reports
Deletion	Allows you to perform deletions on a dataset. For details, see: - Delete with formula - Delete multiple keys - Delete missing keys
Special methods	Allows you to run customised operations based on an SQL script set up by the configurator. For details on special methods, see - Special Method