Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.2
  3. Part 2: Version 10.1.1
  4. Part 3: Version 10.1
  5. Part 4: Version 10.0
  6. Part 5: Version 9.6.1
  7. Part 6: Version 9.6.0

Informatica Data Explorer

Informatica Data Explorer

This section describes new features and enhancements to Informatica Data Explorer.

Column Profile Results

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
.

Curation

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
.

Data Domain Discovery

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
.

Datatype Inference

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

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
.

Enterprise Discovery

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
.

Profile Results Verification

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
.

Scorecards

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
.

Support for bigint Datatype

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
.


Updated September 25, 2020