Course Description

Informatica training is an industry-designed course for mastering the Informatica tool for ETL. You will learn how to configure, install and administer the PowerCenter. As part of the training, you will also do testing and monitoring of data processing using automated, scalable and auditable approach. You will get trained in Workflow Informatica, data warehousing, Repository Management and other processes.

Course Content

Module 01 - Data Warehousing and Cleansing Concepts

What is data warehousing, understanding the extract, transform and load processes, what is data aggregation, data scrubbing and data cleansing and the importance of Informatica PowerCenter ETL

Module 02 - Informatica Installation and Configuration

Configuring the Informatica tool and how to install the Informatica operational administration activities and integration services

Module 03 - Working with Active and Passive Transformation

Understanding the difference between active and passive transformations and the highlights of each transformation

Module 04 - Working with Expression Transformation

Learning about expression transformation and connected passive transformation to calculate value on a single row

Module 05 - Working with Sorter, Sequence Generator and Filter Transformation

Different types of transformations like sorter, sequence generator and filter, the characteristics of each and where they are used

Module 06 - Working with Joiner Transformation

Working with joiner transformation to bring data from heterogeneous data sources

Module 07 - Working with Ranking and Union Transformation

Understanding the ranking and union transformation, the characteristics and deployment

Module 08 - Syntax for Rank and Dense Rank

Learn the rank and dense rank functions and the syntax for them

Module 09 - Router Transformation

Understanding how router transformation works and its key features

Module 10 - Source Qualifier Transformation and Mappings

Lookup transformation overview and different types of lookup transformations: connected, unconnected, dynamic and static

Module 11 - Slowly Changing Dimension in Informatica

What is SCD, processing in xml, learn how to handle a flat file, list and define various transformations, implement ‘for loop’ in PowerCenter, the concepts of pushdown optimization and partitioning, what is constraint-based loading and what is incremental aggregation

Module 12 - Mapplet and Loading to Multiple Designer

Different types of designers: Mapplet and Worklet, target load plan, loading to multiple targets and linking property

Module 13 - Performance Tuning in Informatica

Objectives of performance tuning, defining performance tuning and learning the sequence for tuning

Module 14 - Repository Manager

Managing repository, Repository Manager: the client tool, functionalities of previous versions and important tasks in Repository Manager

Module 15 - Best Practices in Informatica

Understanding and adopting best practices for managing repository

Module 16 - Workflow Informatica

Common tasks in workflow manager, creating dependencies and the scope of workflow monitor

Module 17 - Parameters and Variables

Define the variable and parameter in Informatica, parameter files and their scope, the parameter of mapping, worklet and session parameters, workflow and service variables and basic development errors

Module 18 - Error Handling and Recovery in Informatica

Session and workflow log, using debuggers, error-handling framework in Informatica and failover and high availability in Informatica

Module 19 - High Availability and Failover in Informatica

Configurations and mechanisms in recovery and checking health of PowerCenter environment

Module 20 - Working with Different Utilities in Informatica

Using commands: infacmd, pmrep and infasetup and processing of a flat file

Module 21 - Flat File Processing (Advanced Transformations)

Fixed length and delimited, expression transformations: sequence numbers and dynamic targeting using transaction control

Module 22 - Dynamic Targeting

Dynamic target with the use of transaction control and indirect loading

Module 23 - Working with Java Transformations

Importance of Java transformations to extend PowerCenter capabilities, transforming data and active and passive mode

Module 24 - Unconnected Stored Procedure Usage

Understanding the unconnected stored procedure in Informatica and different scenarios of unconnected stored procedure usage

Module 25 - Advanced Concepts in SCD

Using SQL transformation (active and passive)

Module 26 - Incremental Data Loading and Aggregation

Understanding incremental loading and aggregation and comparison between them

Module 27 - Constraint-based Loading

Working with database constraints using PowerCenter and understanding constraint-based loading and target load order

Module 28 - XML Transformation and Active Lookup

Various types of XML transformation in Informatica and configuring a lookup as active

Module 29 - Profiling in PowerCenter

Understanding what data profiling in Informatica is, its significance in validating content and ensuring quality and structure of data as per business requirements

Module 30 - Workflow Creation and Deletion

Understanding workflow as a group of instructions/commands for integration services and learning how to create and delete workflow in Informatica

Module 31 - Database Connection

Understanding the database connection, creating a new database connection in Informatica and understanding various steps involved

Module 32 - Relational Database Tables

Working with relational database tables in Informatica, mapping for loading data from flat files to relational database files

Module 33 - LinkedIn Connection

Understanding how to deploy PowerCenter for seamless LinkedIn connectivity with Informatica PowerCenter

Module 34 - Connection with Sources

Connecting Informatica PowerCenter with various data sources like social media channels such as Facebook, Twitter, etc.

Module 35 - Pushdown Optimization and Partitioning

Pushdown optimization for load-balancing on the server for better performance and various types of partitioning for optimizing performance

Module 36 - Cache Management

Understanding session cache, the importance of cache creation, implementing session cache and calculating cache requirement

Student feedback

10 Reviews

  • 10
  • 0
  • 0
  • 0
  • 0


out of 5

Course Rating


Bhava Bhardwaj

Perfect Course

One of the best course I have ever come across. Very informative lecture. Presentation was great and very understandable. It is comprehensive that expose learner to core concepts.


Ananya Oberoi

Good Course

Very good experience of listening, good knowledge and explanation. Topics are explained in simple terms making the subject more interesting. Was a good straight forward course.


Varun Rexwal

Excellent Content

The course is overall very good. I really enjoyed the way you explained the concepts and it's very easy for me to understand the concepts. Thank you so much!!


Prabhdeep Singh

Amazing Tutorials

Explanation of the concepts is good, but who is not from this world need a explanation which is easier to understand. Good Contents for the fundamental cover, and motivating one as well.


Rahul Madhok

Best Course

Yes it's a very good match for me ..I learnt the relevant skills very well and hope to get more courses like this is the future. thank you ! SparkAcademy and the trainer for providing the students such a great information respective to their future.


Nancy Singhal

Great Course

Explanations are very useful and are in simple language. Good content and material is provided in he course. overall a satisfactory experience achieved. Superb & simple, the presenter is also very easy to understand.


Karthik Dahiya

Excellent tutorials

The course is pretty good and the homework material. This Course is a great match. Great content and even better delivery.


Pulkit Lunawat

Perfect Course

I found this course excellent as a first step into understanding Informatica ETL. Very clear professional training package.


Prem Singhal

Informative Course

Everything looks good. he started from a good point and challenged our minds. his accent also is good. SparkAcademy provides such amazing tutorials!!


Adiba Naz

Good Course

This course is like an adventure in the Informatica ETL world, the instructor is confident about his knowledge and he also gives tips and tricks all the time to get in it.

Add Reviews & Rate

  • What is it like to Course?

    Course Features

    • Informatica PowerCenter ETL
    • Informatica SQL
    • XML Transformations
    • Joiner Transformation
    • Mapplet
    • Worklet
    • Repository Manager
    • SCD
    • LinkedIn connection
    • Cache management
    • Unconnected stored procedure
    • Dynamic Targeting