12.3.1.1 Icons and Description
This section describes the tools AFCS provides to create connectors.
Table 12-5 Icons and Description
Icon | Description |
---|---|
|
Click the Source button to view the list of all External Data Descriptors created in the setup. Use the External Data Store field to filter and the search icon to quickly locate the EDD you are looking for. After locating the EDD, you can drag the desired EDD on to the canvas. |
|
Click the Target button to view the list of all Application Data Interfaces (ADIs). Use the Applications field to filter and the search icon to quickly locate the ADI you are looking for. |
|
The Mapping component is used to map the source columns to target columns. |
|
The Join component is used to define a join between two entities. Double click this icon and provide the join condition information. |
|
The Filter component is used for define the filter of a given entity. Double click this icon and provide the filter expression information. |
|
The Lookup component is used to define the lookup condition. Double click this icon and provide the lookup information. |
|
The Expression component is used to define defining the derived columns. Double click this icon to define an expression, which can be mapped to the target column. |
|
The Flattened Table To Hierarchy component is used to transform flattened hierarchy entities into parent-child hierarchy entities. |
|
The Transpose (Row to Column) component is used to transpose rows to columns for a given entity. Double click this icon to define the pivot data element and the new columns, which are transposed from multiple rows of the source entity. |
|
The Transpose (Column to row) component is used to transpose columns to rows for a given entity. Double click this icon to define the unpivot data element and new rows which are transposed from the columns of the source entity. |
|
The Aggregation component is used to define a group by and having a clause for aggregation. Double click this icon to define a group by and having a clause for aggregation. |
|
Click this button to remove all the nodes added to the canvas. |