The column profile results include the sum of all values in columns with a numeric datatype.

For more information, see the

Informatica Data Explorer 9.6.0 Data Discovery Guide

.

Use the TOTAL_SUM column in the following relational database views to access the profiling warehouse for information about the sum of values in numeric columns:

IDPV_COL_PROFILE_RESULTS
IDPV_PROFILE_RESULTS_TRENDING

For more information, see the

Informatica 9.6.0 Database View Reference

.

You can curate inferred profile results in both Analyst and Developer tools. Curation is the process of validating and managing discovered metadata of a data source so that the metadata is fit for use and reporting. You can approve, reject, and restore datatypes. You can also approve, reject, and restore data domains, primary keys, and foreign keys. You can hide or show rows containing rejected datatypes or data domains. You can exclude approved datatypes, data domains, and primary keys from column profile inference and data domain discovery inference when yo run the profile again.

For more information, see the

Informatica Data Explorer 9.6.0 Data Discovery Guide

.

Use the following relational database views to access profiling warehouse for information about curated profile results:

IDPV_CURATED_DATATYPES
IDPV_CURATED_DATADOMAINS
IDPV_CURATED_PRIMARYKEYS
IDPV_CURATED_FOREIGNKEYS

For more information, see the

Informatica 9.6.0 Database View Reference

.

You can run data domain discovery on all rows of the source data to verify the inference results for multiple columns at the same time.

For more information, see the

Informatica Data Explorer 9.6.0 Data Discovery Guide

.

You can infer multiple datatypes that match the inference criteria when you run a column profile. You can drill down based on a column datatype in column profile results.

For more information, see the

Informatica Data Explorer 9.6.0 Data Discovery Guide

.

Use the following relational database views to access profiling warehouse for information on inferred datatypes:

IDPV_DATATYPES_INF_RESULTS
IDPV_DATATYPE_FREQ_TRENDING

For more information, see the

Informatica 9.6.0 Database View Reference

.

Discovery search finds assets and identifies relationships to other assets in the databases and schemas of the enterprise. You can use discovery search to find where the data and metadata exists in the enterprise. You can find physical data sources and data object relationships or you can identify the lack of documented data object relationships. You can view the direct matches, indirect matches, and related assets from the discovery search results.

If you perform a global search, the Analyst tool performs a text-based search for data objects, datatypes, and folders. If you perform discovery search, in addition to the text matches, search results include objects with relationships to the objects that match the search criteria.

For more information, see the

Informatica Data Explorer 9.6.0 Data Discovery Guide

.

You can perform enterprise discovery in Informatica Analyst. The enterprise discovery includes column profile and data domain discovery.

For more information, see the

Informatica Data Explorer 9.6.0 Data Discovery Guide

.

You can verify multiple inferred primary key and functional dependency results for a single data object in the Developer tool. When you verify the profile results, the Developer tool runs the profile on all rows of the source data. You can also verify multiple data object relationships and data domains in the enterprise discovery results.

For more information, see the

Informatica Data Explorer 9.6.0 Data Discovery Guide

.

You can export scorecard results to a Microsoft Excel file. The exported file contains scorecard summary, trend charts, rows that are not valid, and scorecard properties.

For more information, see the

Informatica Data Explorer 9.6.0 Data Discovery Guide

.

You can run a profile on a data source with a large number of rows, such as many billions of rows. The profiling warehouse uses the bigint column to handle large volumes of source data.

For more information, see the

Informatica Data Explorer 9.6.0 Data Discovery Guide

.