Í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.
Pros
- 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
Cons
- 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
Comments
Please log in to join the conversation