image

Data Quality – Components and Tools

Data Quality Components

  • Data Profiling
  • Data Quality Analysis
    • Validation
  • Data Cleansing
    • Matching
    • Eliminate Errors, Duplications and Inconsistencies
  • Data Quality Monitoring
    • Views, Reports and Dashboards

Data Quality Tools Examples

  • Informatica Data Quality – IDQ
  • Oracle
  • SAS Data Quality
  • Talend Open Studio for Data Quality
  • IBM InfoSphere QualityStage and Information Analysis

Data Profiling

  • Metadata Discovery
    • Datatypes, Length, Precision, Nullable
    • Keywords
    • Tags
    • Relationships – Primary Key/Foreign Key
  • Descriptive Methods
    • Counts
    • Mean, Max, Min, Distribution
  • Validation Levels
    • Scheme, Entity, Attribute etc

Leave a Reply

Your email address will not be published. Required fields are marked *

9 − 4 =