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

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #22882
    Donna Zehl
    Keymaster

    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:

    1. 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
    
    
    1. 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.

     

     

     

Viewing 1 post (of 1 total)
  • The forum ‘How to’ is closed to new topics and replies.

© 2019 HVR

Try now Contact us