Informatica features for ETL Developers and Professionals

Informatica PowerCenter is an enterprise data integration suite with high availability being fully scalable and high performance providing the foundation for all the data integration projects through the enterprise. Some of the areas included are

  • B2B Exchange
  • Data Warehousing
  • Data Migration
  • Data Governance
  • Data Replication and Synchronization
  • Integration Competency Centers
  • Service Oriented Architectures
  • Master Data Management

Informatica PowerCenter has wide range of features designed for the administrators, developers and professionals. Find the list of Informatica ETL products

  • Metadata manager
  • Development Capabilities
  • A Set of Productivity and Visual Tools
  • Metadata Driven Architecture

The Informatica PowerCenter comprises of three major applications such as Informatica Power Center Client Tools, Informatica PowerCenter Repository and Informatica PowerCenter Server.

Informatica PowerCenter Client Tools: These tools have been designed to enable the Informatica Developer to

  • Manage Repository
  • Report Metadata
  • Mapping and Runtime properties
  • Monitor Session Executions

Informatica PowerCenter Repository: It is the center of Informatica Tools where all the data is stored and where all the metadata for the application is kept. Client Tools and as well as Informatica Server use the Informatica Repository to obtain the data. The repository can be evaluated to the memory of a Personal Computer or a Hard disk where processing of data cannot be possible virtually.

Informatica PowerCenter Server: It is the place where the actions are executed and physically connected to the source and target to fetch the data, apply the transformations and load the data into the target system.

Share on FacebookShare on LinkedInTweet about this on TwitterGoogle+