Automate Data Quality with Informatica IDQ

Data Quality – Overview Data Quality is the process of understanding the quality of data attributes such as data types, data pattern, existing values, and so on. Data quality is also about capturing the score of an attribute based on some specific constraints. For example, get the count of records

How to use Informatica Power Center as a RESTful Web Service Client?

Introduction In today’s world DATA is ubiquitous and critical to the business which eventually increases the need for integration across different platforms like Cloud, Web Service etc.  When it comes to Data Integration, business needs effective communication between their software systems and ETL tool to fulfill their needs. This blog

Can Big Data replace an EDW?

Overview Data Warehousing has been the buzzword for the past two or three decades and big data is the new trend in technology. A question that often arises in our mind is, “Are they similar and will Big Data replace a Data Warehouse”, the reason being, both have similarities like

EDW Readiness Checklist for adding new Data Sources

Overview It is common practice to make changes to the underlying systems either to correct problems or to provide support for new features that are needed by the business.  Changes can be in the form of adding a new source system to your existing Enterprise Data Warehouse (EDW). This blog