Now, you can save your searches to easily repeat search requests.
Saving a search is as easy as 1-2-3:
1. Perform a search. The Search Results page opens. 2. Optionally, choose filters or update your search term. 3. Click Save Search.
You can access saved searches from a list next to the Search field that appears on every page. Saved searches store the search term and any search filters that you apply.
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