Curation in Informatica Developer
Curation is the process of validating and managing discovered metadata of a data source so that the metadata is fit for use and reporting. When you curate metadata in the Informatica Developer, you can approve, reject, and reset the inferred data types or data domains in profile results.
You can approve one data type or data domain for a column. You can hide the rejected data types or data domains for a column. After you approve or reject an inferred data type or data domain, you can reset the data type or data domain to restore the inferred status.
Approving Datatypes
The profile results include the inferred data types, frequency, percentage of conformance, and the inference status for each column in the data source. You can choose and approve a single data type for each column.
1. In the Object Explorer view, select and open a profile.
2. Verify that you are in the Results tab.
3. In the Column Profiling view, select a column to view the value frequencies, patterns, data types, and statistics in the right panel.
4. Under the Details panel, select Data types from the Show list.
The inferred data types for the column appear.
5. Right-click the column that you want to approve and click Approve.
The status of the data type changes to Approved.
6. To restore the inferred status of the data type, right-click the data type and click Reset.
Rejecting Data Types
Informatica Developer displays inferred data types in the profile results by default. You can reject inferred or approved data types. You can choose to show or hide the rejected data types.
1. In the Object Explorer view, select a profile.
2. Double-click the profile to open it.
The profile opens in a tab.
3. In the Column Profiling view, select a row.
4. To reject inferred column data types, select the Data types view in the right panel. Select the inferred data type that you want to reject, right-click the row, and select Reject.
Informatica Developer greys out the rejected data type in the list of data types.
5. To hide the rejected data types, right-click the row and select Hide Rejected.
6. To view the rejected data types, right-click one of the rows, and select Show Rejected.