Informatica Data Quality
April 11, 2014
Informatica Data Quality
Score 9 out of 10
Vetted Review
Verified User
Software Version
9.1, 9.5
Modules Used
- Power Center, Power Exchange, IDQ
Overall Satisfaction
Informatica is used to integrate to various applications like Salesforce, SAP etc. with Oracle and SQL databases. It's used by various departments across the Americas. It helps to optimize the data for various reporting tools.
Pros
- Fact & multi-dimensional loading
- Tracking Changes in slowly changing dimensions
- Integration of data from SAP and Salesforce is better with this ETL tool compared to other tools in the market
- Modularity
Cons
- Several partnerships diminishing the value of technologies
- Unable to get list of objects from Repository (like sources & targets) that don't have any dependency
- Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this.
- Master data management
- Data discovery and profiling
- Data lineage and data archiving
- Increased reporting strategy
- IBM Cognos,ssis
Proven best-practice implementation methodology
Industry-leading data integration technology
End-to-end data migration services
Connects to all major applications and databases
Industry-leading data integration technology
End-to-end data migration services
Connects to all major applications and databases
Comments
Please log in to join the conversation