Create Transformation
After you have registered the extractor and stored the client credentials, you can get started with data transformation.
After you have uploaded the data to the CDF project, you need to create a transformation in CDF.
Perform the following steps to create transformation:
- Navigate to your project in CDF and selectIntegrate>Transformations.Select Transform Data
- On the Transformations screen, click+ Create transformation.Select Create
- Provide a unique name for the transformation.Create Transformation
- Provide a unique external ID.
- Select a data set to limit access to the selected data set and clickNext Step.
- In theTarget data modellist, selectCDF resource typesto ingest data.
- If you are ingesting data into the assets resource type, make sure a parent asset already exists in CDF.
- If you are ingesting data into Sequence rows, specify the external ID for the sequence you want to write to. This defines the target schema.
Create Transformation - In theTarget resource typelist, selectAssets.
- In theActionlist, selectCreate or Update. If you are updating existing data, you must specify how the transformation should set null values.
- SelectKeep existing valuesto not update existing data. This is the default setting.
- SelectClear existing valuesto set existing values to null, for example, when a piece of equipment is removed for maintenance. Use this option to disassociate the asset from its parent in the asset hierarchy.
- ClickCreateto create the transformation. After you create a transformation, you need to select a source for data transformation.TheMapping editoris displayed. Mapping editor helps mapping source and target.Mapping Editor
- In theMapping editor, select the source for transformation. Select the appropriate model, database name, and the table name.
- To map your source data and target, clickSuggestionsand select all that apply.Map Source Data
- After you select the suggestions, clickAccept Selected. You can view the mappings.Then, you are ready to run the transformation.Run Transformation
Provide Feedback