Extraction, Transformation, and Loading - Data Warehouse Systems: Design and Implementation - page 291

Table 8.1 Annotations of the ETL tasks in BPMN
Add Column: adds new derived columns to the flow
Columns List of Col=Expr computing the value of a new column Col added
to the output flow from expression Expr
Add Column: adds new columns to the flow obtained from an SQL query
Columns List of column names added to the output flow
Database Name of the database
Query SQL query
Aggregate: adds new columns to the flow computed by aggregating values from
the input flow, possibly after grouping the records
[Group By] List of column names from the input flow that are used for
grouping. These columns are the only ones from the input flow
that are also in the output flow
Columns List of Col1=AgFct(Col2) or Col1=AgFct(*), where a new
column Col1 in the output flow will be assigned the value
AgFct(Col2) or AgrFct(*)
Convert Column: changes the type of columns from the flow
Columns List of Col:Type, where column Col in the input flow is converted
to type Type in the output flow
Delete Data: deletes tuples from a database corresponding to records in the flow
Database Name of the database
Table Name of the table
Where List of column names from the input flow
Matches List of attribute names from the table
Difference: computes the difference of two flows
Input* List of column names from the two input flows. Input* is used if
the column names are the same for both flows, otherwise Input1
and Input2 are used, each flow defining the column names
Output List of column names from the output flow
Drop Column: drops columns from the flow
Columns List of column names from the input flow that are removed from
the output flow
Input Data: inserts records into the flow obtained from a file
File Nameofthefile
Type Type of the file, such as Text, CSV, Excel, or XML
[Fields] Name of the fields or XPath expressions
Input Data: inserts records into the flow obtained from a database
Database Name of the database
Table | Query Name of the table or SQL query
[Columns] Name of the columns
Insert Data: inserts records from the flow into a file
File

Nameofthefile

Type Type of the file

[Options] Headers if column names are put in the first line of the file; either

Empty or Append depending on whether the file is emptied before
inserting the new tuples, the latter is the default