We are using Informatica PowerCenter for ETL, and simultaneously we are using Informatica Data Quality for data profiling, validation, to remove duplicate entries, and for data cleansing. Ours is a restaurant client, so we get the sales data. There are more than 5,600 franchise sites in our project. We get data from multiple sites once EOD is cleared for all the sites. Some of this data has duplicate records, some has wrong entries or null values. If we directly load the data into our target tables, it may cause errors in querying and reporting tools, leading to data disturbance. We use Informatica Data Quality to maintain good data profiling and data cleansing steps. We had one situation where we did not encounter any data miss, but during reporting, it was showing as if the sales exceeded our daily limit. We thought that the restaurant got profits, but after due diligence, we realized that there were some duplicate entries. We then understood that we needed to have a data quality check, which is why we integrated Informatica Data Quality along with Informatica PowerCenter.
We are using Informatica PowerCenter for ETL, and simultaneously we are using Informatica Data Quality for data profiling, validation, to remove duplicate entries, and for data cleansing. Ours is a restaurant client, so we get the sales data. There are more than 5,600 franchise sites in our project. We get data from multiple sites once EOD is cleared for all the sites. Some of this data has duplicate records, some has wrong entries or null values. If we directly load the data into our target tables, it may cause errors in querying and reporting tools, leading to data disturbance. We use Informatica Data Quality to maintain good data profiling and data cleansing steps. We had one situation where we did not encounter any data miss, but during reporting, it was showing as if the sales exceeded our daily limit. We thought that the restaurant got profits, but after due diligence, we realized that there were some duplicate entries. We then understood that we needed to have a data quality check, which is why we integrated Informatica Data Quality along with Informatica PowerCenter.