[Donna Zehl]

How To:  Create a new column using a derived value using an /IntegrateExpression for a File Location

 

Overview:

How to combine two columns on source, skumodel & serial_num into one combined value column on target (model_serial)

 

Description

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:

Steps

1. Double click on the table’s name in the HVR GUI
2. Add the column manually to the table:

3. Define a /ColumnProperties action on your source location or location group as below:

    /Name=model_serial /Absent /CaptureExpression="{skumodel}||'-'||{serial_num}" /Datatype=varchar2 /Length=200

4. Reinitialize your jobs with “Scripts and Jobs”

 

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.

 

 

 

[Author]

Posts