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 post…

Web Services Overview: Web Services are services available over the web that enables communication and provide a standard protocol for communication. To enable the communication, we need a medium (HTTP) and a format (XML/JSON). There are two parties to the web services, namely Service Provider and Service Consumer. A web service provider develops/implements…

Overview Data cleansing and standardization is an important aspect of any Master Data Management (MDM) project. Informatica MDM Multi-Domain Edition (MDE) provides reasonable number of cleanse functions out-of-the-box. However, there are requirements when the OOTB cleanse functions are not enough and there is a need for comprehensive functions to achieve data…

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 holding…

Overview Data is siloed across wide variety of platforms in an enterprise environment and the data needs to be processed, cleansed, and mastered to ensure it is same across source systems for effective reporting and analysis. To cater to this need, Informatica provides Master Data Management (MDM) product called Multi-Domain Edition…

This blog touches upon the basics of Informatica MDM Fuzzy Matching. Informatica MDM — SDP approach A master data management (MDM) system is installed so that the core data of an organization is secure, is accessible by multiple systems as and when required and does not have multiple copies floating in the system, in…

Teradata — Overview PowerCenter works with many databases, among which Teradata is one of a kind. Informatica PowerCenter integrates Teradata database into any business system and it serves as the technology foundation for controlling data movements. In Informatica PowerCenter, ODBC is used to connect with Teradata tables and its data. This blog helps…

One of the key challenges faced by a growing organization looking to leverage their existing systems is to implement a common interface that provides a means of communication for the systems. This gives rise to Enterprise Service Bus layer to connect large number of diverse applications or services, each using…

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 for which the attribute…