How To:Create a new column using a derived value using an /IntegrateExpression for a File Location
How to combine two columns on source, skumodel & serial_num into one combined value column on target (model_serial)
Since your target is a file location you can’t just simply add the column as an /Extra column with an /IntegrateExpression (because the /IntegrateExpression would use the target DBMS functions) but it can be achieved with a small workaround:
Double click on the table’s name in the HVR GUI
Add the column manually to the table:
Define a /ColumnProperties action on your source location or location group as below:
Please note that adding a /CaptureExpression to your replication can create an overhead because of the expensive round-trip calls made to the database in every captured row. We have an enhancement request in place and our developers are exploring the possibility to make this happen in-flight without leveraging the DBMS functions.
Viewing 1 post (of 1 total)
The forum ‘How to’ is closed to new topics and replies.