A Transformation 1 tab is shown in the right-side pane.
Transformations must contain these basics steps:
- Table Input, for incremental loading process.
- Data Lake Input, extracting data from Data Lake.
- Staging Upsert, loading data to an on-premises database.
For additional information about multiple data flows in a transformation, see Multiple transformation and jobs setup.