Signup as a Tutor

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

Share

Informatica Advanced ETL & Realtime Project Training

Informatica Advanced ETL & Realtime Project Training

Online Instructor led Course

Platform: GoToMeeting

10,000

No Feedback Yet

No Reviews Yet
2 Interested

About the Course


The course teaches the Advanced concepts of Informatica ETL and Realtime Project Training, through classroom/online training with numerous real time scenarios and a couple of projects.

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 ::Advanced ETL

* Different Load Types
* Slowly Changing Dimensions (Type - 1/2/3)
* Indirect Method for Loading
* Parameters and Variables (Mapping and Workflow)
* Different Types of Tasks:
Session
Email
Command
Assignment
Control
Timer
Decision
Event Wait
Event Raise
* Working with Links
* Mapplets & 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

Module_02: Project Training
** Total 2 projects are provided.
1. Basic Level (Demo)
2. Complex Level (Realtime)

* Participants are expected to apply required ETL Concepts and Data Warehousing concepts to build these projects
* Complete assistance and guidance in building the projects from scratch
* Explanation of different phases we have in a realtime project lifecycle
* Giving exposure about the deliverables that are expected from a Developer in a Realtime Project
* Assistance in Interview preparation (both in technical & process oriented aspects) and resume building

** Unix Shell Scripting for Batch Processing:
* Building a unix framework to batch process Informatica workflows
* Shell scripts to trigger the Informatica Workflows
* Triggering the batch from Unix environment
* Integrating the Unix batch framework with 3rd party scheduling tools

Who should attend

Participants having fundamental knowledge on Informatica PowerCenter, DWH & Unix.

Note: If you are looking for Informatica ETL Training from basic level, please check out my other courses under my profile or contact me for more details.

Pre-requisites

Informatica ETL fundamentals,
SQL fundamentals,
Data Warehouse fundamentals,
Unix fundamentals

What you need to bring

Nothing

Key Takeaways

* Ability to design and develop complex mappings
* Configuring Workflows as in real time environment
* Troubleshooting errors/failures
* A realtime hands-on experience of building all together a new Data Warehouse application using Informatica PowerCenter from the scratch.
* Complete exposure to the realtime process oriented things involved in a typical project lifecycle
Content
Reviews
There are no Reviews yet.
Questions and Comments

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


There are no Reviews yet.
cash back100% Money Back Guarentee

About the Trainer

Raj picture

Raj

Informatica & Oracle Certified Professional


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

Course Id: 28108