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