Page History
| Anchor | ||||
|---|---|---|---|---|
|
| Table of Contents | ||
|---|---|---|
|
...
Update Type | Description |
|---|---|
Insert | To append or add data to the end of the existing data. |
Truncate | To replace all the existing data with the new values. This should be used with caution as it will delete any existing data. |
Update | Update the value of fields in the database table where a matching row exists in the transformation flow. This option overwrites existing data and should be used with caution. |
Update & Insert | Update the value of fields in the database table where a matching row exists in the transformation flow. This option overwrites existing data and should be used with caution. If not matching row exists then insert a new row. |
| Styleclass | |
|---|---|
|
| |
How to Configure an Output Step
...
- Choose database from the list. Only writeable data sources will be shown.
- Choose a table creation option. Click here to understand the table creation options.
- Continue with the selected process:
- If Use Existing was selected, select a pre-existing table to write data into. Then skip to step 4.
- If Create If Not Exists was selected, then enter a new table name. You can optionally select any table fields that you would like to index (note: indexes are used to improve query performance. If in doubt about this option, please contact your system administrator). Move on to step 4.
- If Drop Existing was selected, then enter a new table name. Move on the step 5.
- If Drop if Metadata Conflicts was selected, then enter a new table name, also specify whether the existing table is to be dropped in case there are more fields in the transformation flow than in the table. Then skip to step 4.
Choose an update type to indicate how the table will be updated. Click here to understand all the options.
Note For Update and Update & Insert options, additional row matching is required. This is done by choosing Join for the identifier or matching field, and then Set to indicate which field to update. If no option is selected, the field will not be used in the join or be updated as part of the flow.
- Enable the button to run this flow IF in preview mode. SEE WARNING NOTE.
- Once the configuration is done, click on the Apply button to save these changes.
| Styleclass | ||
|---|---|---|
| ||