Informatica Online Training

MKTraining offers the best Informatica online training designed by IT Professionals with the IT industry specialists. As our trainers are experienced certified trainers, they will share their experience, tips and tricks in the Informatica training. Informatica online training is offered to consultants, companies so that they can meet all the challenges in their respective technologies. Informatica is a service oriented architecture and also has the capability to share service and resource across several machines. Informatica delivers enterprise data integration and management software powering analytics for big data and cloud. Dataware housing concepts will be taught prior to Informatica. Informatica PowerCenter is a widely used extraction, transformation and loading (ETL) tool used in building enterprise data warehouses. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse.

Highlights of Informatica training:-

* Very in depth course material with Real Time Scenarios for each topic with its Solutions for Informatica Online Trainings.

* We provide Case studies for Informatica training.

* Sessions are scheduled based upon your comfort by our Highly Qualified Trainers and Real time Experts.

* We provide you with your recorded session for further Reference.

* Normal Track, Fast Track and Weekend Batches are also provided for Informatica Training.

* We also provide Cost Effective and Flexible Payment Schemes.

 

Informatica Training Course Content

 

Data warehousing Concepts

Introduction To Data warehousing

  • Data Warehousing Concepts
  • Data warehousing (what/Why/How)
  • Data Modelling(Schemas, FACTS and DIMENSIONS)
  • Slowly Changing Dimensions
  • Metadata

Power Center Components and User Interface

  • Power Center Architecture
  • Power Center Client Tools
  • Lab – Using the Designer and Workflow Manager

Source Qualifier

  • Source Qualifier Transformation
  • Lab Project Overview
  • Lab A – Load Payment Staging Table
  • Source qualifier Joins
  • Lab B – Load Product Staging Table
  • Source Pipelines
  • Lab C – Load Dealership and Promotions Staging Table and Real time issues

Expression, Filter, File Lists and Workflow Scheduler

  • Expression Editor
  • Filter Transformation
  • File Lists
  • Workflow Scheduler
  • Lab – Load the Customer Staging Table and Real time issues

Joins, Features and Techniques

  • Joiner Transformation
  • Shortcuts
  • Lab A – Load Sales Transaction Staging Table
  • Lab B – Features and Techniques I and Real time issues

Look ups and Reusable Transformations

  • Lookup Transformation
  • Reusable Transformations
  • Lab A – Load Employee Staging Table
  • Lab B – Load Date Staging Table and Real time issues

Debugger

  • Debugging Mappings
  • Lab – Using the Debugger

Sequence Generator

  • Sequence Generator Transformation
  • Lab – Load Date Dimension Table and Real time issues

Lookup Caching, More Features and Techniques

  • Lookup Caching
  • Lab A – Load Promotions Dimension Table
  • Lab B – Features and Techniques II
  • Review and more Lab Activities and Real time issues

Router, update Strategy and Overrides

  • Router Transformation
  • Update Strategy Transformation
  • Expression Default Values
  • Source Qualifier Override
  • Target Override
  • Session Task Mapping Overrides
  • Lab – Load Employee Dimension Table and Real time issues

Dynamic Lookup and Error Logging

  • Dynamic Lookup
  • Error Logging
  • Lab – Load Customer Dimension Table
  • Unconnected Lookup, Parameters and Variables

Unconnected Lookup Transformation

  • System Variables
  • Mapping Parameters and Variables
  • Lab – Load Sales Fact Table

Sorter, Aggregator and Self-Join

  • Sorter Transformation
  • Aggregator Transformation
  • Active and Passive Transformations
  • Data Concatenation
  • Self-Join
  • Lab – Reload the Employee Staging Table and Real time issues

SCD type1 – LAB

SCD type2 – LAB

SCD type3 – LABMapplets

  • Mapplets
  • Lab – Load Product Daily Aggregate Table
  • Review and more Lab Activities and Real time issues

Workflow Variables and Tasks

  • Link Conditions
  • Workflow Variables
  • Assignment Task
  • Decision Task
  • Email Task
  • Lab – Load Product Weekly Aggregate Table

More Tasks and Reusability

  • Event Raise Task
  • Event Wait Task
  • Command Task
  • Reusable Tasks
  • Reusable Session Task
  • Reusable Session Configuration

Worklets and More Tasks

  • Worklets
  • Timer Task
  • Control Task
  • Lab – Load Inventory Fact Table
Keywords:

Informatica Training, Informatica Online Training From India, Informatica Online Training Hyderabad, Informatica Online Training Institute, Informatica Training Videos, Informatica Developer, Informatica Training Material, Informatica Training Tutorial, Informatica Training Classes, Informatica Interview Questions, Informatica Online Course.

India|Philippines|New Zealand|US|UK|Canada|Australia|Germany|Switzerland

Hyderabad|Mumbai|Bangalore|Kolkata|New Delhi|Chennai|Kerala|Pune|Lucknow