Course Overview
Informatica Powercenter 9.6.1 Advanced:
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 training you shall be equipped with advanced skills needed for Informatica development, architecture and various transformations.
The training will include the following;
- Normalizer Transformations in Informatica 1 hour
- Stored Procedure Transformation in Informatica 2 hours
- Expression Transformation in Informatica (Advanced) 1 hour
- Re-Usable Transformation in Informatica 1 hour
- Debugging Mappings in Informatica 2 hours
- Stored Procedure Transformation in Informatica 2 hours
- Transaction Control Transformation in Informatica 1 hour
- Command Line Utilites 1 hour
- Performance Tuning in Informatica 3 hours
– Methodology
– Mapping Design
– Memory and Cache Optimization
– Partitions
- Summary and Quick Revision
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