Transformation flows are created by combining various steps through connectors. Use the information below to learn more about these steps and connectors.
These are the three types of steps that can be included in a transformation flow.
Include an input step to define where to extract your data from. The following types can be used:
|
Use a transformation step to transform or convert the connected data.
|
Save the transformed data into a database using an output step.
|
Once a step is added to the canvas, right-click on it to see the functions that can be performed on it.
These are explained below:
Function | Description |
---|---|
Copy | To create a copy of the step. |
Break Connections | To break any connections that the steps has with other steps. |
Delete | To delete the step. |
Connectors are used to join steps together and create a relationship between them. Data will flow from one step to another step. Click on a step to reveal its connecting points. These points are then used to connect one step to another. The flow of a connector is represented with an arrowhead at the end of it.
These rules are applicable on step connecors (running left to right).
Once a connection is created between steps, right-click on it to see the functions that can be performed.
These are explained below:
Function | Description |
---|---|
Edit Flow | To configure the mapping between the data fields in the connecting steps. |
Break Connections | To delete the selected connection. |
Once a connection is created between two steps, it can be broken or deleted. Simply right-click on one of the steps, and click on Break Connections. This will break all the connections associated with that step.
Alternatively right-click on the connector itself and select Break Connections.
Confirmation will be required before the connection is deleted. Just click on the Confirm button to do so.