Let’s chat? - We're online
Greetings from Mazenet! Please share a few details about yourself.
Book a time slot
Book a time slot
Powered by Mazenet

Unlock the Power of Your
Data with Informatica

Contact Us


Get Started Today
Objectives

  • This course aims to provide participants with in-depth knowledge and skills in using Informatica PowerCenter for data integration and transformation.

  • The training covers key components, concepts, and advanced topics of Informatica, ensuring participants can effectively manage and optimize data workflows, transformations, and performance tuning.

Course Outcome

Designer, Repository Manager, Workflow Manager, Workflow Monitor, and PowerCenter Admin Console.
Understand Informatica Concepts and Architecture: Participants will gain a comprehensive understanding of Informatica's architecture and its components.
Work Efficiently with Sources and Targets: Participants will learn to handle relational and flat file sources and targets within Informatica.
Execute Transformations with Precision: Participants will develop skills in implementing various active and passive transformations, including Expression, Lookup, Joiner, Aggregator, and Slowly Changing Dimensions (SCD).
Optimize and Monitor Workflows: Participants will acquire expertise in managing workflows, sessions, scheduling, and monitoring to ensure efficient data processing.
Create Reusable Objects and Advanced Optimization: Participants will be able to create reusable transformations, mapplets, worklets, and apply advanced performance tuning techniques.

Why Mazenet?


  • Expert Faculty

    Our Faculty comprises of 300+ SMEs with many years of experience. All our trainers possess a minimum of 8+ years of experience.

  • Proven Track Record

    We have served over 200+ global corporate clients, consistently maintaining a 99% success rate in meeting training objectives for 300+ technologies with quick turnaround time.

  • Blended Learning

    We provide course content over any platform that our clients prefer. You can choose an exclusive platform or a combination of ILT, VILT, and DLP.

  • Learning Paths

    The learning paths are very defined with clear benchmarks. Quantitative assessments at regular intervals measure the success of the learning program.

  • Case Study

    We have amassed over 10,000 case studies to support training delivery. Candidates will be trained to work on any real-time business vertical immediately after the training.

  • 24*7 Global Availability

    We are equipped to conduct training on any day, date or time. We have delivered training pan India, Singapore, North America, Hong Kong, Egypt and Australia.

Delivery Highlights

  • Customized Training Modules

    Training programs are highly flexible with module customizations to suit the requirements of the business units.

  • Certification

    The training can be supplemented with appropriate certifications that are recognized across the industry.

  • Multi-language Support

    Course content can be delivered in English, Spanish, Japanese, Korean or any other language upon request.

  • Personalized Training Reports

    Candidates are assessed individually at regular intervals and are provided unique learning suggestions to suit their learning calibre.

  • Industry-Oriented Training

    Industry-oriented training, completing which, candidates can be immediately deployed for billable projects.

  • Diverse Training Platforms

    Choose from Instructor-Led Training, Virtual Instructor-Led Training, Digital Learning Platform and Blended Training platforms

Contact Us
Ready to get started?
Let's chat.


Get Started Today

Course Preview

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • PowerCenter Admin Console

  • Informatica Architecture

  • Working with Relational Sources
  • Working with Flat Files

  • Working with Relational Targets
  • Working with Flat File Targets

  • Expression
  • Lookup – Different Types of Lookup Caches
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Rank
  • Router
  • Java Transformation
  • UDT Transformation
  • Aggregator
  • Source Qualifier
  • Update Strategy
  • Normalizer
  • Union
  • XML Source, Target, and Transformations
  • Stored Procedure
  • Slowly Changing Dimension (SCD Type 1, Type 2 – Date, Flag, and Version, Type 3)

  • Manager Overview
  • Source and Target Connection
  • Flat File
  • Native
  • ODBC
  • External Loaders
  • Tasks
  • Creating Tasks
  • Types of Tasks
  • Sessions and Workflows
  • Creating Sessions
  • Creating Workflows
  • Server Configuration
  • Assigning Server to Workflows
  • Session Pre-defined Variables
  • Workflow Link Conditions
  • Recover Tasks and Workflows
  • Parameter File Management
  • Target Load Types
  • Indirect Loading
  • Constraint-based Load Ordering
  • Scheduling Workflow
  • Parameter and Variables
  • Target Load Plan
  • File List Management
  • SQL Overrides at the Session Level

  • Monitor Overview
  • Workflow Monitor Views
  • Running and Monitoring Workflows
  • Scheduling
  • Workflow and Session Logs
  • Monitor Configuration

  • Reusable Transformations and Sessions
  • Mapplets
  • Worklets

  • Performance Tuning
  • Error Handling and Recovery in Informatica
  • Pushdown Optimization
  • Copying Objects
  • Importing and Exporting Objects
  • Deployment Groups