Step 4 Enable the link

  1. Upon executing the SQL scripting in the "Staging Upsert step", enable the link between “Table Input” and “Data Lake Input”.

    See this diagram:

    ../images/image4.png

    Then run the transformation. This is to avoid that the operation ends up in an SQL error.

  2. Run the Transformation.