loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Share

Informatica PowerCenter v9.6.1 ETL (Online) Training

Informatica PowerCenter v9.6.1 ETL (Online) Training

Online Instructor led Course

Platform: GoToMeeting

10,000

No Feedback Yet

No Reviews Yet
9 Interested

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
* DEMO PROJECT
* 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:
Filter
Router
Sequence Generator
Rank
Sorter
Joiner
Union
Source Qualifier
Expression
Aggregator
Lookup (Connected/Unconnected)
Normalizer
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:
Session
Email
Command
Assignment
Control
Timer
Decision
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.

Pre-requisites

* 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
Gallery
Document

Course Content - Informatica PowerCenter...

Informatica PowerCenter ETL Course...

Informatica PowerCenter ETL Course...

Informatica PowerCenter ETL Course...

ETL Central Google Group

ETL Central Google Group

Course Materials Shared on Google...


Reviews
There are no Reviews yet.
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions


Document

Course Content - Informatica PowerCenter...

Informatica PowerCenter ETL Course...

Informatica PowerCenter ETL Course...

Informatica PowerCenter ETL Course...

ETL Central Google Group

ETL Central Google Group

Course Materials Shared on Google...


There are no Reviews yet.

About the Trainer

Raj picture

Raj

Informatica & Oracle Certified Professional


Expert in ETL, Data Integration, Data Quality & Metadata Management

Course Id: 23353