Creating a new transformation

  1. Click File > New > Transformation
  2. Alternatively click the + icon and click Transformation.

    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.