When you run the Informatica Data Quality resource, the scanner performs the following tasks:
1. Verifies that the catalog has the source metadata for the resource.
For example, to migrate Oracle profile results, you must first create and run the Oracle resource in Catalog Administrator.
2. Verifies that the matching resource has profile results.
3. Verifies that the matching resource has curation decisions.
4. If curation results do not exist, the scanner migrates the results to the catalog.
5. If curation results exist, the scanner compares the timestamp of the curation decisions in the catalog with the curation decision in the profiling warehouse. The scanner migrates and overwrites the curation results if the curation results in the profiling warehouse have the latest timestamp.
For example, you reject the SSN data domain for a column in Employee table in the catalog on 05/01/19. You accept the SSN data domain for the same column in the Developer tool on 05/02/2019. You run the Informatica Data Quality scanner on 05/03/19. The curation decision for the data domain SSN in the profiling warehouse has the latest timestamp. The scanner migrates and overwrites the curation decision in the catalog. The data domain SSN displays accepted in the catalog.
Note: Enterprise Data Catalog displays SYSTEM in the Assigned By column for a data domain asset when you curate a data domain in the Developer tool or Analyst tool and the decision is migrated to the catalog.
6. Merges the data domain inferred results.
For example, in the Developer tool, you accept the data domains SSN and Age in the Employee table. In Enterprise Data Catalog, you accept the data domains Address and City in the same Employee table. When you run the Informatica Data Quality scanner, the scanner merges the data domain accepted results and displays SSN , Age, Address, and City as inferred data domains for the Employee table in the catalog.
7. Automatically accepts a data domain if the inference percentage exceeds the Auto Accept Percentage value.
8. Identifies the top 1,000 maximum values for a column and migrates the values to the catalog.
9. In Catalog Administrator, when you click Missing Report link tab in the Connection Assignment section, the exported file does not display the details of source and target objects that are not linked.