After the mapping has been defined, there are many ways in which
you can configure it further:
- Modify the target value using the Compose Mapping Expression editor.
- Apply built in functions.
- Apply user-defined functions.
- Insert operators.
- Include additional fields.
Use the appropriate node to configure different parameters:
- Use DataUpdate nodes to configure expressions and the WHERE
clause.
- DataInsert nodes can only have expressions.
- DataDelete nodes can only have WHERE clauses.
For these nodes, the existing method of updating multiple columns
in a row is still supported. However, you can map these nodes, as well as
the Warehouse node, as a one-to-one mapping. This enables you to merge multiple
mappings into a single row in a table, or split a mapping into multiple one-to-one
mappings (one for each row).