How To: Map different source tables/column names to target
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 Local Data Processing.
Steps:
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
Step 1) Right mouse click on the table A in Tables list in Local Data Processing.
Step 2) Select TableProperties in New Action
Step 3) Select Group as Target
Step 4) Check box for /BaseName and populate with the name that you wish to give which is B in our case.
Step 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
Step 1) Right mouse click on the table A in Tables list in Local Data Processing.
Step 2) Select ColumnProperties in New Action
Step 3) Select Group as Target
Step 4) Check box for /Name which will be the name of the column on the source. In our case it will be c2
Step 5) Check box for /BaseName which will be the name of the column on the target. In our case it will be c2_target
Step 6) The setup should look similar to the below image. And the action will look similar to ColumnProperties /Name=c2 /BaseName=c2_target
