Informatica Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

675 Learners


LMS Access

365 days

Course duration

30days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

Introduction to Informatica

  • Informatica & Informatica Product Suite
  • Informatica PowerCenter as ETL Tool
  • Informatica PowerCenter Architecture
  • Component-based development techniques

Informatica PowerCenter Transformations

  • Visualize PowerCenter client tools
  • Data Flow
  • Create & execute mapping
  • Transformations & their usage.

Data Integration and Data Warehousing Fundamentals

  • Data Integration Concepts
  • Data Profile and Data Quality Management
  • ETL and ETL architecture
  • Brief on Data Warehousing

ETL Scenarios using Informatica

  • Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
  • Advanced techniques - Flat File, XML File
  • Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)

Performance Tuning, Design Principles & Caches

  • Performance Tuning Methodology
  • Mapping design tips & tricks
  • Caching & Memory Optimization
  • Partition & Pushdown Optimization
  • Design Principles & Best Practices

Informatica - Workflow Manager

  • Workflow Introduction
  • Tasks
  • Workflow tools
  • Connections 

Informatica Advanced Features

  • Incremental Aggregation
  • Mapplet Implementation
  • Target Load Plan
  • Constraint based Loading
  • Mapping Parameters
  • Mapping Variables
  • Session parameters
  • Link Conditions 

Informatica Designer - Advanced

  • Mapping Introduction
  • Source Qualifier
  • Ports
  • Mapping -Table to Table
  • Mapping flat File to Table
  • Connected/Unconnected Transformations
  • Active and Passive Transformation
  • Source Qualifier Transformation
  • SQl Override-Source Qualifier Transformation
  • Mapping Source Qualifier as Filter
  • Source qualifier to join Data
  • Filter Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Stored procedure Transformation (Connected & Unconnected)
  • Union Transformation
  • XMl Transformation
  • Mapping Wizards
  • Implementing Type-I, Type-II, Type-III and Mappings 

Informatica Installation and Configuration

  • Overview of Informatica configuration 
  • Integration Services
  • Installation of Informatica.
  • operational administration activities.

Course Description

Course Obejctives

  • Introduction of Informatica basics.
  • Learn about the data warehousing concepts
  • How the Dimension tables used and OLAP
  • Learn PowerCenter components
  • Informatica Architecture
  • Learn about source qualifiers
  • Look Caching and techniques
  • Worklets tasks
  • Advanced concepts on Informatica V10.

Who should learn Informatica ETL Tool?

  • ETL & SQL Developers and Business Intelligence Professionals
  • Database & Mainframe Professionals, Project Managers

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Siva

Excellent Training, learnt alot and cleared certification in 3 months.

Satya

I have very great experience of the Informatica Developer training. Instructor was a professional trainer with the good practical experience. Thank you.

Karthik

I liked each and every video that came with the Informatica Training. The quality was the highest, there was full interactivity and real world examples to help the learner go on a self-paced learning path. Keep it up!