Informatica
440 Case Studies
A Informatica Case Study
The National Department of Commercial Registration (DNRC), part of Brazil’s MDIC, had to collect and consolidate commercial registration data from all 27 states across multiple time zones to support faster, more accurate industrial policy and greater government efficiency. Data arrived in many formats (various Oracle, SQL Server and DB2 flat files), at different times, and with inconsistent quality, leaving analysts limited to simple statistics and making integration slow and resource‑intensive.
By deploying Informatica PowerCenter Advanced Edition to standardize enterprise data integration, MDIC consolidated, cleaned and synchronized records into a trusted, single view of 53 million companies. The solution cut time to answer key policy questions from one week to one minute, enabled timely strategic planning, revealed market and business trends, improved support for fledgling businesses, and integrated data quickly regardless of source or datatype.