Data Quality Analyst User Guide(4)

The tasks that you can perform in the Analyst tool depend on the Informatica products that you use. Use theAnalyst tool to accomplish the following tasks:

¨Run profiles. Create and run profiles to analyze the structure and content of enterprise data and identify

strengths and weaknesses. After you run a profile, you can view the rows from the profile results. You can alsoadd profiled columns to scorecards and add column values to reference tables.

¨Create rules in profiles. Create and apply rules within profiles. A rule is reusable business logic that defines

conditions applied to data when you run a profile. Use rules to further validate the data in a profile and tomeasure data quality progress.

1

Informatica data quality Analyst guide version 9

¨Score data. Create scorecards to score the valid values for any column or the output of rules. Scorecards

display the value frequency for columns in a profile as scores. Use scorecards to measure and visuallyrepresent data quality progress. You can also view trend charts to view the history of scores over time.¨Manage reference data. Create and update reference tables that analysts and developers use in data quality

standardization and validation rules. Create, edit, and import data quality dictionary files as reference tables.Create reference tables to establish relationships between source data and valid and standard values.Developers use reference tables in Standardizer and Lookup transformations in the Developer tool.

¨Manage bad records and duplicate records. Filter records, edit records, and set record status. Merge groups

of duplicate records from a consolidated record table into a single record.

Informatica Analyst Interface

Use the Analyst tool interface to perform Analyst tool tasks.

The Analyst tool interface has tabs, headers, views, and a Navigator. Use the Navigator to browse projects andperform tasks on projects and folders.

When you log in to the Analyst tool, the Browse: Projects tab appears. The tab displays views and the Navigator.The tab also displays the icons and the Actions menus that you can use to perform tasks in the Navigator and inviews.

When you click the link for an object in a view, the object opens in a tab. After you perform a search, the Analysttool displays the search results in a tab. You can keep multiple tabs open in the Analyst tool interface. You cannavigate between tabs.

The Analyst tool has the following header items:¨Log Off. Log out of the Analyst tool.

¨Manage. Set user preferences to open metadata bookmarks in the Analyst tool or Developer tool and delete

database connections.

¨Help. Access help for the current tab.

¨Search. Search for objects and folders in projects.

Informatica Analyst Navigator

Use the Navigator to browse projects and folders and their contents. After you log in to the Analyst tool, theNavigator appears in the left pane.

When you select a project in the Navigator, you can select a view to view the project contents, descriptiveinformation about the project, and permissions on the project.The Navigator displays the following types of objects:

¨Projects. Highest object in the Navigator hierarchy. It is the top-level container for all projects that you create.¨Folders. Child object of a project. Organize domain objects within a project in folders.

Refresh the Navigator to get the latest version of all objects in the Navigator. Multiple users can add projects andfolders that appear in the Navigator.

The Navigator has an Actions menu that you can use to perform tasks on projects and folders. You can also right-click projects and folders to perform the same tasks.

2 Chapter 1: Introduction to Informatica Analyst

Informatica data quality Analyst guide version 9

Use the Navigator to perform the following tasks:¨Create projects and folders.¨Manage projects and folders.

¨Refresh the projects and folders that appear in the Navigator.

Informatica Analyst Views

The Analyst tool has views for the projects and folders that you select in the Navigator. Objects that open in tabsalso have views. Use the Actions menu or right-click objects to perform tasks related to the view. You can alsoclick icons in the view panels to perform the common tasks related to the view.

The Contents View and the Properties View are the views for the top-level Projects container. The Projectscontainer contains the projects that you create in the Navigator.

After you select a project or folder, the Analyst tool interface displays the following views:¨Contents view. Displays project or folder contents and properties for selected objects.¨Properties view. Displays project or folder properties.¨Security view. Displays user permissions on the project.

Contents View

Use the Contents view to view project and folder information. In the Contents view, you can create and add dataobjects and profiles to projects and folders. You can perform project and folder management tasks.

After you select a project or folder in the Navigator, click the Contents view to view project or folder contents.The Contents view displays project or folder contents in the Contents panel. When you select an object in theContents panel, the Analyst tool displays the object properties in the Properties panel.You can perform the following tasks in the Contents view:¨Open an object.

¨Duplicate projects, folders, and objects.¨Rename projects, folders, and objects.¨Move folders and objects.

¨Delete projects, folders, and objects.¨Add a flat file to a project or folder.¨Add a relational table to a project or folder.¨Create a custom profile.¨Create a reference table.