Page History
...
Note |
---|
In rarer circumstances, the target tables may not exist in advance. In these cases Yellowfin can create the table for you, provided you have the right security access. The Create if Not Exists option will create the table if it does not exist. Typically this will only happen the first time a flow is run, after which the existing table will be used. The Drop Existing will always delete and re-create the table, thus deleting any data that may have been stored in that table - and should be used with caution. Similarly the Drop if Meta-Data Conflict will drop and re-create the table if there is a mismatch between the table structure and the data contained in the flow. This option is also destructive to data and should be used with caution. |
Styleclass | ||
---|---|---|
| ||
Anchor | ||||
---|---|---|---|---|
|
...
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 | ||
---|---|---|
| ||
...