How To: Map different source tables/column names to target

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #12259
    ggoodrich
    Keymaster

    How To: Map different source table/column names to target table/column names

    Scenario:

    In certain situations, it can become necessary to have different table name/Column name on the target than that on the source. This article describes how to achieve that using HVR.

     

    A] Replicating the table name on the source as a different table name on the target.

     

    Here is an example of a Table A on the source which is mapped to Table B on the target

    1) Right mouse click on the table A in Tables list in HVR.

    2) Select TableProperties in New Action

    3) Select Group as Target

    4) Check box for /BaseName and populate with the name that you wish to give which is B in our case.

    5) Which should look similar to below image. Action would look like TableProperties/ BaseName=B

     

     

     

    B] Replicating a column name on the source as a different column name on the target

     

    For the sake of understanding let us assume we have a table A with columns c1 and c2 on source and we will see how to replicate column c2 on source as c2_target on target

     

    1) Right mouse click on the table A in Tables list in HVR

    2) Select ColumnProperties in New Action

    3) Select Group as Target

    4) Check box for /Name which will be the name of the column on the source. In our case it will be c2

    5) Check box for /BaseName which will be the name of the column on the target. In our case it will be c2_target

    6) The setup should look similar to the below image. And the action will look similar to ColumnProperties /Name=c2 /BaseName=c2_target

     

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

© 2020 HVR

Test drive Contact us