Create a transform map
Create a transform map to match the columns from the staging table to the columns in the target table. The transformation helps to convert the data from the source table into metric data.
Vorbereitungen
If you already have manual Metric Definition in the system before the import, you must change the type of metric definition to Automated and the method type to External source.
Role required: sn_esg.program_manager
Warum und wann dieser Vorgang ausgeführt wird
A map is transformed when you import data from a staging table such as Watershed Data [sn_esg_watershed_data] to a target table such as Metric Data [sn_grc_metric_metric_data]. By default, there are three transform maps available for each table when you import data from Watershed.
Prozedur
- Navigate to .
- Open the import set that you created.
- Under Related Links, select Transform.
- On the Specify Import Set and Transform map form, move the required maps from the Available column to the Selected maps run in order column.
- Select Transform.