Information Analyzer

Techopedia explains Information Analyzer

Information Analyzer has extensive data profiling capabilities. It is available with a user interface that includes a set of controls designed for integrating development work flow. The four major data profiling functions within Information Analyzer are:

• Column Analysis: Generates a full-frequency distribution and examines column values to infer properties and definitions such as statistical measures and domain values.
• Primary Key Analysis: Identifies candidate keys for one or more tables and aids in testing column combinations or columns to determine whether the candidate is suitable for forming a primary key
• Foreign Key Analysis: Examines the relationships and contents across tables, thereby identifying foreign key and referential check integrity.
• Cross-Domain Analysis: Identifies overlap in values between columns and redundancy of data between tables.