Data mapping examples
Input data mappings contain the following YAML
structure:
"inputs": [
{
"filename": "<input_filename_table>",
"table": "<SCV table name>"
},
{
"filename": "<input_filename_query>",
"query": "<valid SQL query on SCV database>"
}
]
Output data mappings contain the following YAML
structure:
"outputs": [
{
"filename": "<input_filename_table>",
"table": "<SCV table name>",
"update_mode": "<update mode for the specified output table>",
"delete_mode": "<delete mode for the specified output table>",
"delete_condition": "<delete condition on the specified output table>"
}
]
where:
* update_mode: Possible values are "Insert", "Merge". Optional. Default is "Insert".
* delete_mode: Possible values are "Physical", "None". Optional. Default is "None".
* delete_condition: A valid SQL where clause on the specific SCV table. Optional. No default value. Can only be specified when delete_mode = "Physical".