Ínformatica data quality
Software Version
9.5.1
Modules Used
- Developer tool,Analyst,IDD
- Profile,data domain discovery,logical data object,mappings,mapplets,cleansing functions,address doctor,exception record management,scoreacarding,identity matching,web services,data services
- Human tasks,classifier,data processor and all other transformations
Overall Satisfaction with Informatica Data Quality
Customer creation process - using web services for matching and address cleansing. Managing exception record management for both bad and duplicate record management. Currently using across the organization for scorecarding to cover DQ problems.
- It's a great tool for profiling and score carding and cleansing bad data
- Matching, standardization, address doctor, exception record management
- Data services, web services, entity discovery, show lineage
- Scorecard export functionality for bad records - and it only displays the first 100 records
- There are no filtering conditions on scorecarding
- In IDD we cannot import bad record tables or duplicate records table as we did it in 9.1
- Profiling results should be displayed in charting mode, as with other tools
- Cleaner data across systems
- Better governance
Informatica data quality is better than all the products today except that competitors have better report formatting. For example: Global ID and Talend have better profiling reports for business users ( charting.. etc). Informatica is lacking in this area.
Using Informatica Data Quality
100 - Customer,vendor,material,production. Etc
1 - etl,sql,reporting
- Customer creation
- Dip check
- Cleansing functionality
- Reports on 3rd party tools
- On going quality check
Evaluating Informatica Data Quality and Competitors
No - Not replaced any of the tools
- Product Features
- Product Usability
- Product Reputation
- Vendor Reputation
- Existing Relationship with the Vendor
Product functionality
Once in a year