INFORMATICA TUTORIAL: Complete Online Training

Training Summary


Beside supporting normal ETL process that deals with large volume of data, Informatica tool provides a complete data integration solution and data management system. In this tutorial,you will learn how Informatica does various activities like data cleansing, data profiling, transforming and scheduling the workflows from source to target in simple steps etc.

What should I know?


Nothing! this course assumes you an absolute beginner to Informatica Powercenter.

Syllabus


1. Introduction to Informatica

2. Informatica Architecture Tutorial

3. How to Install Informatica PowerCenter

4. How to Configure Clients and Repositories in Informatica

5. Source Analyzer and Target Designer in Informatica

6. Mappings in Informatica

7. Workflows In Informatica

8. Workflow Monitor in Informatica

9. How to Debug Mappings in Informatica

10. Session Objects in Informatica

11. Introduction to Transformations in Informatica and Filter Transformation

12. Source Qualifier Transformation in Informatica

13. Aggregator Transformation in Informatica

14. Router Transformation in Informatica

15. Joiner transformation in Informatica

16. Rank Transformation in Informatica

17. Sequence Generator Transformation in Informatica

18. Transaction Control Transformation in Informatica

19. Lookup and Re-usable transformation in Informatica

20. Normalizer Transformation in Informatica

21. Performance Tuning for Transformation in Informatica

22. Informatica Interview Questions & Answers