Informatica Analyst
This section describes new Analyst tool features in version 10.0.
Asset Versioning
Effective in version 10.0, when the Model repository is integrated with a version control system, the version control system protects assets from being overwritten by other members of the development team. You can check assets out and in, and undo the checkout of assets.
For more information, see the "Model Repository" chapter in the Informatica 10.0 Analyst Tool Guide.
Profiles
This section describes new Analyst tool features for profiles and profile results.
Column Profile
Effective in version 10.0, you can right-click the data object in the Library workspace to create a column profile. The data object and folder options are updated automatically in the profile wizard.
For more information about column profile, see the "Column Profiles in Informatica Analyst" chapter in the Informatica 10.0 Data Discovery Guide.
Column Profile Results
Effective in version 10.0, column profile results have the following new features and enhancements:
- •View profile results in summary view and detailed view. The summary view provides a high-level overview of the profile results in a grid format. The detailed view displays column-specific information in detail.
- •View outliers in the summary view and detailed view of profile results. An outlier is a pattern, value, or frequency for a column that does not fall within an expected range of values.
- •View profile results for the latest profile run, historical profile run, and consolidated profile run. You can view the profile results for any historical profile run. When you run the consolidated profile run, you can view the latest results for each column in the profile.
- •Compare profile results for two profile runs, and view the profile results in summary view and detailed view.
- •View profile results for a profile with JSON or XML data sources.
- •Add business terms, tags, and comments to a profile and columns in the profile.
For more information about column profile results, see the "Column Profile Results in Informatica Analyst" chapter in the Informatica 10.0 Data Discovery Guide.
Decimal Data Type
Effective in version 10.0, you can create profiles with columns that have the Decimal data type with a precision of up to 38 digits.
For more information, see the Informatica 10.0 Data Discovery Guide.
JDBC Connectivity
Effective in version 10.0, you can specify a JDBC connection as a profiling warehouse connection for IBM DB2 UDB, Microsoft SQL Server, and Oracle database types. You can create column profiles, rule profiles, domain discovery, and scorecards with a JDBC connection as a profiling warehouse connection.
For more information, see the Informatica 10.0 Data Discovery Guide.
Object Versioning
Effective in version 10.0, when the Model repository is integrated with a version control system, the version control system protects objects from being overwritten by other members of the development team. You can check profiles out and in, undo the checkout of profiles, and view and restore historical versions of profiles.
For more information about object versioning, see the "Column Profiles in Informatica Analyst" chapter in the Informatica 10.0 Data Discovery Guide.
Rules and Filters
Effective in version 10.0, you can add or edit rules and filters when you create a column profile.
For more information, see the Informatica 10.0 Data Discovery Guide.
Scorecard Filter
Effective in version 10.0, you can create and apply a filter on the metrics of a scorecard.
For more information about scorecard filter, see the "Scorecards in Informatica Analyst" chapter in the Informatica 10.0 Data Discovery Guide.