Informatica Tutorial - Beginner to Expert Level

Overview

Informatica Tutorial - Beginner to Expert Level at Udemy will introduce you to work with the Power Center version 10.x/9.6x to create, execute, as well as administer, monitor and schedule ETL processes and understand how these are used in data mining operations and enterprise data warehouse setup.

Students at Informatica Tutorial - Beginner to Expert Level at Udemy will:

• Understand Data Warehouse Concepts and ETL Concepts

• Describe Informatica PowerCenter architecture & its different components

• Use PowerCenter 10x/9.x components to build Mappings, Tasks, Workflows

• Describe the basic and advanced features functionalities of PowerCenter 10.0/9.6 transformations

• Understand Workflow Task and job handling

• Describe Mapping Parameter and Variables

• Perform debugging, troubleshooting, error handling and recovery

• Learn different types of cache available and how to calculate cache requirement and implement session cache

• Execute performance tuning and Optimization

• Identify and explain the functionalities of the Repository Manager tool

• Identify how to handle services in the Administration Console

• Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation

• Gain insight on ETL best practices using Informatica

• Understand all the basic interview questions for all the transformations and real time scenarios