2015-06-02

What is Informatica :

Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases.

Informatica can communicate with all major data sources (mainframe/ RDBMS/ Flat Files/ XML/ VSM/ SAP etc), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.

SYLLABUS FOR INFORMATICA :

Module 1: Data warehouse Concepts

Module 2: E T L Informatica Power Center 9.X.X

Module 3: Introduction to Informatica

Module 4: Power Center Components

Module 5: Informatica Building Blocks

Module 6: Different Transformations

Module 7: Informatica Advanced Concepts

Module 8: Workflow task

Module 9: Session level Properties

Module 10: Performance Tuning

Module 11: Case studies

DURATION-Around 50 Hours

Show more