Dependencies

All transformations are captured in the Transformation Editor. In addition to the transformation, it is specified which sources are used and which targets are written to with a transformation. Within a sheet, you can visually see how the data flow is within this sheet and in what order the transformations should reasonably run so that the tables used are already filled before the transformation is executed.

These dependencies can also be determined across sheets. They are not displayed graphically but can be determined through the use of objects with the same name (same connection, same schema, and same table name) across sheets.

When creating a run, dependencies are determined according to the above rules between all involved transformations and persisted in the sqts_batch_instance_dependency table. As long as not all tasks on which a task depends are in status "Finished", the dependent task remains in status "Dependency Wait"