...

Overview

Transformation flows are created by combining various steps through connectorsconnections. Use the information below to learn more about these steps and connectorsconnections.

Steps

These are the three types of steps that can be included in a transformation flow.

...

Input Steps

Include an input step to define where to extract your data from. The following types can be used:

...

Transformation Steps

Use a transformation step to transform or convert the connected data.

...

Output Steps

Save the transformed data into a database using an output step.

...

Step Functions

Once a step is added to the canvas, right-click on it to see the functions that can be performed on it.

...

...

Connections

Connectors Connections 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 a connection is represented with an arrowhead at the end of it.

Connection rules

These rules are applicable on step connecors on connections (running left to right). 

• An input step can be connected to only one transformation or output step.
• A transformation step cannot be connected to an input step, but to another transformation or output step.
• All types of transformation steps, except the split step, can only be connected to one other step.
• A split step can be connected multiple times.
• Connections can only be made to an output step, but it cannot be the origin of a connection.

Connector Functions

Once a connection is created between steps, right-click on it to see the functions that can be performed.

...

Breaking a Connection

Once a connection is created between two steps, it can be broken or deleted. Simply right-click on the connector itself and select Break Connections.

...