The

Data Transformation

system consists of a design environment for designers and a production environment where applications run transformation services. Use the Informatica Developer tool to design and implement data integration solutions.

You can use the Developer tool to extract data from multiple sources, transform the data according to business logic that you build in the client application, and load the transformed data to targets. You can also run a profile to analyze the structure and content of your data, and to determine the quality of your data.

You can access data in relational databases, flat files, web services, and social media web sites.

Administrative tools include the Informatica domain, application services that process data, repositories to store metadata, Informatica Administrator (the Administrator tool), and Informatica Developer (the Developer tool).

The Administrator tool, the repositories, and application services run on a single machine. The Developer tool can run on one or more machines.