Data Type Conflict
Enterprise discovery identifies data type conflicts in columns. A data type conflict is a mismatch of inferred and documented data types of a column after you run enterprise discovery. An inferred data type is the data type that the Analyst tool derives for a data source column based on the column data. A documented data type is the declared data type for a column in the source database.
Enterprise discovery might infer a different data type for a column based on the column data compared to the documented data type of a column. For example, the enterprise discovery can infer a column with a documented string data type as a date data type. You can review the data type conflict, choose the most appropriate data type date for the column, and approve it.
Viewing Data Type Conflicts
When you open a profile with data type conflicts from the Summary view, the Analyst tool highlights the data type conflicts in Red.
1. Run a profile to perform enterprise discovery.
2. Verify that you are in the Summary view.
3. Under the Column Profiling section, click Conflicting inferred vs. documented data types to view the data type conflicts in column profile results.
A list of profiles that contains columns with data type conflicts appear in the right pane.
4. Select a row in the right pane, if required.
The hyperlinks to the profile appear in Blue color.
5. Click the profile name link or column name link to open the profile.
The profile opens and displays the data type conflicts in Red color. You can choose to curate the inferred data types to resolve the data type conflict.
6. To curate the data types, select a row with the conflicting data types and click data types view.
7. Click Actions and then select Approve or Reject.
8. To go back to the Summary view, click Back to Enterprise Discovery..