Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Informatica PowerCenter v9.6.1 ETL (Online) Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: GoToMeeting

Course ID: 23353

Course type: Online Instructor led Course

Platform: GoToMeeting

Raj picture
No Reviews Yet

Date and Time

Not decided yet.

Raj picture

Informatica & Oracle Certified Professional

About Raj

Expert in ETL, Data Integration, Data Quality & Metadata Management
No reviews currently

About the Course

The course teaches the fundamental and advanced concepts of Informatica PowerCenter v9.6.1, through classroom/online training and numerous hands-on lab exercises and real time scenarios. Students will gain a clear understanding of the product and acquire the solid foundation needed to make them efficient PowerCenter developers.

Duration:: 25 Hours

*** Exclusive Benefits Offered***
* Numerous Exercises
* Realtime Scenarios
* Concepts of Unix Required for Informatica
* Topic wise course materials
* Lifelong subscription to 'ETL Central' Google Group
* Assistance in Resume Building
* Job Oriented Training

Session Timings:
* Weekday Batches: (Mon - Sat)
Any one hour in the below mentioned timings as per the slot availability
Morning Hours: 05:00 AM - 10:00 AM IST
Evening Hours: 10:30 PM - 11:30 PM IST

* Weekend Batches: (Sat & Sun)
Two sessions (each 2 hours) per day both on Sat & Sun

Topics Covered

Module_01 :: Overview of Data Warehousing

* Introduction to Data warehouse (What/Why/How)
* Star schema/Snowflake schema/Galaxy schema
* Dimensions/Facts tables.
* Slowly Changing Dimensions and its types.

Module_02 :: Basic ETL

* Introduction to Informatica PowerCenter
* (E)xtraction, (T)ransformation and (L)oading Process
* PowerCenter Tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor)

* Source and Target Object Definitions
* Transformation Concepts (Types, Classifications, Basic uses)
* ODBC & Relational Connections"

* Using Flat Files
* Using XML Files
* Transformations:
Sequence Generator
Source Qualifier
Lookup (Connected/Unconnected)
Stored Procedure (Connected/Unconnected)
Update Strategy
Transaction Control
Java Transformation
SQL Transformation (Query/Script)
XML Generator
XML Parser

Module_03 ::Advanced ETL

* Different Load Types
* Slowly Changing Dimensions (Type - 1/2/3)
* Indirect Method for Loading"

* Mapplets and Reusable Transformations
* Parameters and Variables (Mapping and Workflow)

* Different Types of Tasks:
Event Wait
Event Raise

* Working with Links
* Worklets
* Scheduler
* Parallel and Serial Batching.

* User Defined Functions
* Incremental Aggregation
* Constraint Based Loading
* Target Load Plan
* Performance Tuning
* Pushdown Optimization
* Wizards
* Partitioning
* Version Control
* Debugger

** Unix Batch Framework
** Realtime Project Lifecycle Explanation
** Demo Project Explanation

Who should attend

Any technology aspirant, be it freshers or experienced.


* SQL Basics
* Good internet connectivity (min 512kbps)

What you need to bring

Regular practice of topics covered is what expected at the least for every next class""

Key Takeaways

* Understanding the concepts of Data Warehousing
* Ability to design and develop complex mappings
* Configuring Workflows as in real time environment
* Troubleshooting errors/failures
* Gain hands-on experience with multiple exercises and various real time scenarios and a Demo Project
* Confidence to excel your career as an efficient Informatica Developer/Consultant


No reviews currently

Gallery (7)


Course Content - Informatica PowerCenter...


Post your requirement and let us connect you with best possible matches for Informatica Training Post your requirement now