Informatica is an ETL tool used for extracting the data from various sources , transform the data and finally load the data into a centralized data server.
Informatica Powercenter has a service oriented architecture (SOA) that provides the ability to scale services and share resources across multiple machines.
The Informatica PowerCenter data integration platform support business intelligence, data warehousing, data migration and cloud application integration and big data integration
PowerCenter can be integrated with an extensive catalog of products for expanded capabilities in big data management, cloud integration, data quality, data security, data governance and master data management.
key features of PowerCenter?
Support Team-based design, development and administration features that enable use on multiple projects
Connectivity and transformations that work with numerous source and target systems.
Development productivity tools that enable data profiling, application prototyping and testing validation.
A repository that captures, displays and administers process and design metadata.
A glossary and role-based tools enable business and IT to apply business rules.
Who benefits from using PowerCenter?
Informatica's products are oriented to large and midsize enterprises, with multiple integration uses and projects and expand resulting integration applications.
Overview of DataWarehousing,
What is ETL?,
informatica 8.6 ,
Introduction of Different components
Workflow Manager ,
Source Qualifier ,
Working with relational Sources and flat files,
Target Qualifier ,
Working with Relational Targets and flat file ,
Introduction of mapplets ,
Active and Passive Transformations ,
Creation of mapping with expression Transformation