The first task to getting your source data into the entity database
is to analyze your source data for mapping to UMF.
Procedure:
- Identify data you want to load into the entity database.
- Ensure the data is consistent and complete.
- Identify width of incoming UMF segment element values versus the
width of their corresponding database table columns.
- Identify invalid characters in the source data.
The results of your analysis might present several options such as:
- Using DQM rules to correct data with invalid characters.
- Using DQM rules to truncate data with a larger width than their corresponding
database table columns.
- Asking external data source providers to supply more complete data.
- Loading only fields with valid data.