Step 3 StagingUpsert

  1. Drag and drop a StagingUpsert stage, from the Design - Stage menu.
  2. Link these stages by pressing SHIFT and clicking DataLakeInput. Draw a line towards the StagingUpsert stage.
  3. Within the StagingUpsert stage, specify this information:
    1. In the Target Table field, specify the table name to be created in the staging database.
    2. Click Get Defaults and click Get Updated fields.
    3. Check the SQL syntax. To change the syntax, click the SQL statement results in the Simple SQL Editor.
    4. Execute the statements.