Course Overview
Informatica Powercenter 9.6.1 Beginners:
Informatica is a widely used ETL tool which is used to extract the raw data and load it into the target data after making some transformations. ETL stands for Extract Transform Load which refers to the processes performed when transforming raw data to a data warehouse or data mart or relational databases. Informatica is an easy to use tool and it also has a simple visual interface like forms.
Through this beginners training you shall be equipped with skills needed for Informatica development, architecture and various transformations.
The training will include the following;
- Introduction to Informatica
- Informatica Architecture
- Download and Installation of Informatica Power center
- Configuration of Client and Repositories in Informatica
- Mappings and Workflows in Informatica
- Workflow Monitor in Informatica
- Source Analyzer and Target Designer in Informatica
- Filter and Router Transformations
- Source Qualifier and Aggregator Transformations
- Joiner Transformation
- Rank and Sequence Generator Transformation
- Lookup Transformations in Informatica
- Update Strategy Transformation in Informatica
- Expression Transformation in Informatica
- Union Transformation in Informatica
Target Customers:
- Software developers
- Analytics professionals
- ETL or Data warehouse professionals
- Graduates who wanted to enter IT field
- Mainframe developers and architects
Pre-Requisites:
- Basic computer and Database knowledge is required
- Knowledge of SQL will be helpful
- Passion to learn about Informatica is must