Problem: Data isn't mapping or transforming correctly during the import process.
Steps to troubleshoot:
- Verify data mapping rules under Admin > Configuration > Data Mapping. Ensure that each field from the source is correctly mapped to the corresponding asset type.
- Ensure that SQL queries used for data mapping follow best practices, like proper use of indexing, efficient queries, and normalization.
- For transformations or calculated fields, confirm that all transformations are correctly defined in the SQL query used for mapping.
- Run the mapping on a test dataset to ensure it performs as expected. Check if data appears correctly in the staging tables first, then in the asset tables.
- Verify your query returns unique names for mapping to an asset.