Skip to main content
Search:
Skip navigation links

Informatica Data Explorer

Informatica Data Explorer combines powerful data profiling and mapping capabilities with unparalleled ease of use to empower data experts to investigate, document, and resolve data quality issues.

Data Profiling

Using a combination of automated discovery and interactive analysis processes, Informatica Data Explorer defines the content, structure, and quality of highly complex data structures. Informatica Data Explorer alerts you to hidden inconsistencies and incompatibilities between data sources and target applications, and it helps you communicate what you’ve discovered about the data with others in your organization.

Features

Three-Dimensional Data Profiling

  • Column profiling analyzes all the values within each column or attribute and discovers metadata and content quality problems
  • Single-table structural profiling examines each attribute/column in relation to every other attribute/column within a table, looking for dependency relationships and uncovering functional dependencies, primary keys, and data structure quality problems
  • Cross-table structural profiling compares data between tables, determining which attributes contain overlapping or identical sets of values, and it discovers duplicate data across systems; foreign keys, synonyms, and homonyms; and values corrupting data integrity
Informatica Data Explorer uses sophisticated, three-dimensional profiling to define the content, structure, and quality of highly complex data structures.

Open, Standards-Based Repository

  • Store an accurate profile of data in an open, standards-based repository so that it can easily be accessed and reused
  • Profile data on an ongoing basis and analyze changes to source data over time to improve data quality

Configurable Tagging

  • Generate tags—information  about project management, data explanations, or transformation logic—against any data element stored in the repository
  • Readily identify data quality issues, document them, flag them for resolution, and communicate this information throughout the organization via email

Benefits

  • Accelerate IT project delivery schedules by automating data investigation and discovery processes
  • Minimize the risk of data quality problems proliferating throughout the organization
  • Enhance the success of enterprise-wide data quality initiatives by giving data profiling responsibility to those who understand it best—business data analysts and data stewards
  • Instill confidence that the data upon which the business relies to make strategic decisions is high quality