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.

시작하기 전에

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

이 태스크 정보

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.

프로시저

1. Navigate to Operational Sustainability Management > Watershed > Import Sets.
2. Open the import set that you created.
3. Under Related Links, select Transform.
4. 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.
5. Select Transform.